Vlookupstr

Vlookupstr 2 CRX for Google Sheets

A Free Productivity Add-on

Published By William.W

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

Download CRX

Download

6.58 KB

Chrome Store

Tech Specs

  • • Type: Google Sheets Add-on
  • • Latest Version: 2
  • • Price: Freeware
  • • Offline: No
  • • Developer: William.W

User Reviews

  • 6 Votes, Average: 4.83 out of 5
  • • 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

VLOOKUPSTR(search_key, range, index, case_insensitive)

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

Download Vlookupstr 2

More Add-ons to Consider (Similar or Related)