Vlookup edited

[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

 

[Gary''s Student]

=IF(ISERROR(VLOOKUP(B1,C14,2)),"",VLOOKUP(B1,C14,2))

 

[Gord Dibben]

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

 

[israel]

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

 

[Gord Dibben]

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

 

[Don Guillett]

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))

 

[Ken Wright]

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.......................