if(isna(vlookup),vlookup)

  • Thread starter Thread starter marta
  • Start date Start date
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
 
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.
 
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...
 
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
 
Back
Top