if(isna(vlookup),vlookup)

M

marta

Hi,
what is the purpose of including the IF and ISNA functions
in this VLOOKUP?
=IF(ISNA(VLOOKUP($C8,'position_master.market_val'!
$B$13:$R$60000,17,FALSE)),0,VLOOKUP
($C8,'position_master.market_val'!
$B$13:$R$60000,7,FALSE)/1000000)

thank you!
Marta
 
A

Andy B

Hi

If the VLOOKUP figure is not found in the list, an error will be returned to
the cell. This ISNA function checks if the VLOOKUP will produce an error and
if it does 0 is displayed instead.
 
M

marta

thank you!
-----Original Message-----
Hi

If the VLOOKUP figure is not found in the list, an error will be returned to
the cell. This ISNA function checks if the VLOOKUP will produce an error and
if it does 0 is displayed instead.

--
Andy.





.
Click to expand...
 
M

marta

thank you!
-----Original Message-----
Marta,

Isna replaces " #N/A with a "0" in your formula......if
Click to expand...
that is that you made an error in the true
argument :VLOOKUP
 
Top