View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Eliminate #N/A in Vlookup formulas

One way:

=IF(ISNA(VLOOKUP(A2,Table,12,0)),"",VLOOKUP(A2,Tab le,12,0))

--
Biff
Microsoft Excel MVP


"kkeim" wrote in message
...
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!