Vlookupstr (igkbgmafodaojojegoijmffeogjfnpda): This function performs a none-full-match string searching, which can not be done by VLOOKUP.... Read More > or Download Now >
Vlookupstr for Google Sheets
Tech Specs
- • Type: Google Sheets Add-on
- • Latest Version: 2
- • Price: Freeware
- • Offline: No
- • Developer: William.W
User Reviews
- • Rating Average
- 4.83 out of 5
- • Rating Users
- 6
Download Count
- • Total Downloads
- 1
- • Current Version Downloads
- 1
- • Updated: May 11, 2017
Vlookupstr is a free Productivity Add-on for Google Sheets. You could download the latest version crx file and install it.
More About Vlookupstr
This function acts like the build-in function VLOOKUP. But it performs a non-full-match string searching, which can not be done by VLOOKUP.
Example:
=VLOOKUPSTR(A1, A2:B26, 2, FALSE)
To Check for the string of the cell A1 in the column A from A2:B26, if any cell contains ( not equal to) the string, for example, A1= "File" and A6="File Menu", then the function returns the cell value of B6 in this example.
And the differences are:
1. as above, if the search_key is the substring of the cell in the first column, then the function will return as found.
2. can perform a none case insensitive search
3. always assume the column to be searched is not sorted
search_key
The value to search for.
range
The range to consider for the search.
index
The column index of the value to be returned.
case_insensitive
Indicates whether the searching is case insensitive.
---
Note:
This is an open source project, you can find the source code on:
https://github.com/willwhui/VLOOKUPSTR