IF Value
Apparently the value of K2 can be found in the range B2:B8. So Vlookup does not return NA#. So ISNA returns FALSE. So you don't
get the first value from IF ("") (which you would get if ISNA had returned TRUE), but the second one, "X".
Exactly the opposite is the case in your second formula.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"scheduler" wrote in message ...
|I can get the "X" to appear in this formula:
| =IF(ISNA(VLOOKUP(K2,B2:B8,1,FALSE)),"","X")
|
| But cannot get it to appear in this formula:
| =IF(ISNA(VLOOKUP(K2,B2:B8,1,FALSE)),"X","")
|
| Why?????????????
|