k2 does contain value from b2:b8 and I am wanting an "x" to appear,,,how do I
make this happen?

"David Biddulph" wrote:

Your second formula is correct for returning X if the expression is True.
If X isn't appearing, it is presumably because your ISNA expression is
returning False. Your ISNA will return true (and thus display X) if K2
contains something which doesn't occur in B2:B8.
--
David Biddulph

"scheduler" wrote in message
...
But how do I get the "X" to appear if true? That is my objective.

"Niek Otten" wrote:

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?????????????