Not displaying the "#N/A"
 

Hi everyone,

I've a vlookup command that results in a "#N/A" answer on the cell. How
can I format the cell so that it won't display the "#N/A"?


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=517779

Not displaying the "#N/A"
 

IF(ISNA(VLOOKUP(what,range,col,false)),"",VLOOKUP( what,range,col,false))

HTH
--
AP

"ledzepe" a écrit
dans le message de
...

Hi everyone,

I've a vlookup command that results in a "#N/A" answer on the cell. How
can I format the cell so that it won't display the "#N/A"?


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile:
http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=517779

Not displaying the "#N/A"
 

=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten

"ledzepe" wrote in
message ...

Hi everyone,

I've a vlookup command that results in a "#N/A" answer on the cell. How
can I format the cell so that it won't display the "#N/A"?


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile:
http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=517779

Not displaying the "#N/A"
 

=IF(ISNA(lookup_formula),"",lookup_formula)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ledzepe" wrote in
message ...

Hi everyone,

I've a vlookup command that results in a "#N/A" answer on the cell. How
can I format the cell so that it won't display the "#N/A"?


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile:
http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=517779