Vlookupstr 2 CRX for Google Sheets

A Free Productivity Add-on

Published By William.W

Sponsored Links

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


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.

Sponsored Links

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.

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

The value to search for.

The range to consider for the search.

The column index of the value to be returned.

Indicates whether the searching is case insensitive.

This is an open source project, you can find the source code on:

Download Vlookupstr 2

More Add-ons to Consider (Similar or Related)