Eliminate #N/A in Vlookup formulas
try the traditional formula
=IF(ISNA(VLOOKUP(A2,"table",12,0)),"",VLOOKUP(A2," table",12,0))
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"kkeim" wrote:
I need Vlookup to return a blank if there is no value to be found in the
table. IE: Vlookup,a2,"table",12,false returns #N/A if there is not exact
match in "table" (Another spreadsheet). How do I eliminate this? It's driving
me nuts!
|