Google Drive Spreadsheets: Combining IF and VLOOKUP
google-sheets, gs-vlookup
Solution
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")
Problem
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...