Google Drive Spreadsheets: Combining IF and VLOOKUP

google-sheets gs-vlookup
user2761030 picture user2761030 · Nov 21, 2013 · Viewed 32.1k times · Source

I'm trying to work out a formula for combining an IF statement and a VLOOPUP.

Basically, I want the formula to return a value if a value was found through VLOOKUP, or to return something else if not found...

I have experimented with 

=IF(VLOOKUP(A1,$B$2:$B$31, 1, 0),"FOUND","NOT FOUND!")

... but this doesn't seem to work.

Many thanks for any thoughts you might have...

Answer

mvinayakam picture mvinayakam · Oct 31, 2014

An old thread but would like to submit a cleaner solution for the Vlookup example or places where you want to use the value returned by a formula-

=IFERROR(VLOOKUP(A1,$B$2:$B$31, 1, 0),"NOT FOUND")

Related questions

Google Sheet pulling data from another spreadsheet if match

So I'm stuck with something. I have two spreadsheets, column A on each are similar but not identical, some values are on one spreadsheet but not the other. Is it possible for me to pull data from spreadsheet 2, based on …

Read More
VLOOKUP within IMPORTRANGE

I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a VLOOKUP: =importrange("otherurl";cell("address";vlookup(value("201608"),"All_nodevice!$A$16:$C$1000",2,false))) I get a general error. Does IMPORTRANGE support …

Read More
How to calculate the sum of VLOOKUP with two criteria?

I'm looking for a clean(er) way (than using SUMIF with a third row) to calculate the sum of the results from, say, a VLOOKUP that checks both the first and the second row for matching criterion. So, given the …

Read More