| 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????????????? | | | | | | |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
as stated in my first post,,it comes up blank
"Niek Otten" wrote: 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????????????? | | | | | | |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
You wrote in that post that you could get the X with that formula!
Perhaps better to do this stepwise. In C1: =VLOOKUP(K2,B2:B8,1,FALSE) In C2: =ISNA(C1) In C3: =IF(C2,"","X") Now you should be able to see where it is going wrong. Don't hesitate to post again; then also post the values in B2:B8 and in K2 -- Kind regards, Niek Otten Microsoft MVP - Excel "scheduler" wrote in message ... | as stated in my first post,,it comes up blank | | "Niek Otten" wrote: | | 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????????????? | | | | | | | | | | | | | | | |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
My problem is, I want the X to appear and I only get a blank with the second
formula, when the finds the value I want an x to appear, can you help? Thanks for your help and responses "Niek Otten" wrote: You wrote in that post that you could get the X with that formula! Perhaps better to do this stepwise. In C1: =VLOOKUP(K2,B2:B8,1,FALSE) In C2: =ISNA(C1) In C3: =IF(C2,"","X") Now you should be able to see where it is going wrong. Don't hesitate to post again; then also post the values in B2:B8 and in K2 -- Kind regards, Niek Otten Microsoft MVP - Excel "scheduler" wrote in message ... | as stated in my first post,,it comes up blank | | "Niek Otten" wrote: | | 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????????????? | | | | | | | | | | | | | | | |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
<I only get a blank with the second formula
That is why I advised you to use your FIRST formula: =IF(ISNA(VLOOKUP(K2,B2:B8,1,FALSE)),"","X") I also asked you to post the values of B2:B8 and K2. -- Kind regards, Niek Otten Microsoft MVP - Excel "scheduler" wrote in message ... | My problem is, I want the X to appear and I only get a blank with the second | formula, when the finds the value I want an x to appear, can you help? Thanks | for your help and responses | | "Niek Otten" wrote: | | You wrote in that post that you could get the X with that formula! | | Perhaps better to do this stepwise. | In C1: | =VLOOKUP(K2,B2:B8,1,FALSE) | In C2: | =ISNA(C1) | In C3: | =IF(C2,"","X") | | Now you should be able to see where it is going wrong. | Don't hesitate to post again; then also post the values in B2:B8 and in K2 | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "scheduler" wrote in message ... | | as stated in my first post,,it comes up blank | | | | "Niek Otten" wrote: | | | | 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????????????? | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Value
The value of column k are names. As I place those names in column b I want an
x to appear. What I will do is create a column for each day of the week, so I will have 7 columns like B and 7 columns like k. The x will appear each column like k "Niek Otten" wrote: <I only get a blank with the second formula That is why I advised you to use your FIRST formula: =IF(ISNA(VLOOKUP(K2,B2:B8,1,FALSE)),"","X") I also asked you to post the values of B2:B8 and K2. -- Kind regards, Niek Otten Microsoft MVP - Excel "scheduler" wrote in message ... | My problem is, I want the X to appear and I only get a blank with the second | formula, when the finds the value I want an x to appear, can you help? Thanks | for your help and responses | | "Niek Otten" wrote: | | You wrote in that post that you could get the X with that formula! | | Perhaps better to do this stepwise. | In C1: | =VLOOKUP(K2,B2:B8,1,FALSE) | In C2: | =ISNA(C1) | In C3: | =IF(C2,"","X") | | Now you should be able to see where it is going wrong. | Don't hesitate to post again; then also post the values in B2:B8 and in K2 | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "scheduler" wrote in message ... | | as stated in my first post,,it comes up blank | | | | "Niek Otten" wrote: | | | | 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 | |
|
|
Linear Mode
