ExcelBanter - IF Value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Value (https://www.excelbanter.com/excel-discussion-misc-queries/117182-if-value.html)

scheduler

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

Niek Otten

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

scheduler

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

David Biddulph

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

scheduler

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

Niek Otten

IF Value

scheduler

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

Niek Otten

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

scheduler

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

Niek Otten

IF Value

scheduler

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

All times are GMT +1. The time now is 09:59 AM.