Eliminate #N/A in Vlookup formulas
Hi,
if you are using excel 2003 use
=IF(ISERROR(VLOOKUP(A3,Sheet2!A:B,2,FALSE)),"",VLO OKUP(A3,Sheet2!A:B,2,FALSE))
"Eduardo" wrote:
Hi
=iferror(Vlookup,a2,"table",12,false ),"")
if this helps please click yes
"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!
|