| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Value
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????????????? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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????????????? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
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????????????? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
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????????????? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
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????????????? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
Use your first formula
-- Kind regards, Niek Otten Microsoft MVP - Excel "scheduler" wrote in message ... | 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????????????? | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
