Vlookup edited

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

Hello all you wonderfulhelp,

Is it possible to avoid "NA" when using "vlookup" function. I need info
only where
it brings results.

Thank you
 
Example of using ISNA rather than ISERROR which hides all errors.

=IF(ISNA(VLOOKUP(G1,$A$1:$F$31,2,FALSE)),"",VLOOKUP(G1,$A$1:$F$31,2,FALSE))


Gord Dibben MS Excel MVP
 
Thank you for your prompt reply, but I am a bit confused. I should point out,
my result vlookup column is L2:L385. I assume your formula should be
applied once I have the result ffrom "vlookup", in "conditional formating".
Please advise.

Thank you
 
VLOOKUP formula requires at least a two-column table.

See help on VLOOKUP

Conditional Formatting does not come into play.

You replace your existing VLOOKUP formula with the one I supplied.

If a value cannot be found the NA will be suppressed.

Post your current VLOOKUP formula so's we can see what to modify.


Gord
 
You can look up in one column, but why???? cuz you get what you looked for,
if it's there.
=IF(ISNA(VLOOKUP(E1,C2:C22,1,0)),"",VLOOKUP(E1,C2:C22,1,0))
 
General syntax when you have a formula (your_formula) that may return a #N/A
error and you want nothing returned rather than #N/A

=IF(ISNA(your_formula),"",your_formula)

Regards
Ken.......................
 
Back
Top