if(isna(vlookup),vlookup)

[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

 

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

 

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





.

 

[marta]

thank you!

-----Original Message-----
Marta,

Isna replaces " #N/A with a "0" in your formula......if

that is that you made an error in the true
argument :VLOOKUP