Not displaying the "#N/A"

[ledzepe]

Hi everyone,

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

 

[Ardus Petus]

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

HTH
--
AP

"ledzepe" <[email protected]> a écrit
dans le message de
news:[email protected]...

 

[Niek Otten]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)