Hello all you wonderfulhelp,

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

Thank you
--
smile

=IF(ISERROR(VLOOKUP(B1,C1:D4,2)),"",VLOOKUP(B1,C1: D4,2))
--
Gary''s Student - gsnu200851

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

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


Gord Dibben MS Excel MVP


On Thu, 7 May 2009 09:26:02 -0700, israel
wrote:

Hello all you wonderfulhelp,

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

Thank you

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

--
smile


"Gord Dibben" wrote:

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

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


Gord Dibben MS Excel MVP


On Thu, 7 May 2009 09:26:02 -0700, israel
wrote:

Hello all you wonderfulhelp,

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

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

On Thu, 7 May 2009 10:31:02 -0700, israel
wrote:

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Thu, 7 May 2009 10:31:02 -0700, israel

wrote:

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

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




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

--
smile


"Gord Dibben" wrote:

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

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


Gord Dibben MS Excel MVP


On Thu, 7 May 2009 09:26:02 -0700, israel

wrote:

Hello all you wonderfulhelp,

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

Thank you