I have this formula

=IF(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)=" ","DNP",(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FAL SE)))

What I would like this to do is if there is nothing in the cell it should
put DNP and if there is the numbers 0,1,2,3,4 I want it to put those numbers
in the cell. Can you help me

Thank you Dwalston

Doesn't your formula do that?

dwalston wrote:

I have this formula

=IF(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)=" ","DNP",(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FAL SE)))

What I would like this to do is if there is nothing in the cell it should
put DNP and if there is the numbers 0,1,2,3,4 I want it to put those numbers
in the cell. Can you help me

Thank you Dwalston

--

Dave Peterson

.. if there is nothing in the cell ..
I presume you are referring to the vlookup's return? Don't see anything
wrong with your formula per se. It could be a case of a white space throwing
expected returns off (the white space in the cell will look like the
"nothing"). You could try wrapping a TRIM around the vlookup, like this:
=IF(TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$124,$P$1,FAL SE))="","DNP",TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$12 4,$P$1,FALSE)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dwalston" wrote:
I have this formula

=IF(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)=" ","DNP",(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FAL SE)))

What I would like this to do is if there is nothing in the cell it should
put DNP and if there is the numbers 0,1,2,3,4 I want it to put those numbers
in the cell. Can you help me

Thank you Dwalston

Hi
when I put a number in the cell it is still putting the DNP on sheet in
stead of the number that is in the cell I only want the DNP when there is
nothing in the cell

Thank you for the help

"Max" wrote:

.. if there is nothing in the cell ..
I presume you are referring to the vlookup's return? Don't see anything
wrong with your formula per se. It could be a case of a white space throwing
expected returns off (the white space in the cell will look like the
"nothing"). You could try wrapping a TRIM around the vlookup, like this:
=IF(TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$124,$P$1,FAL SE))="","DNP",TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$12 4,$P$1,FALSE)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dwalston" wrote:
I have this formula

=IF(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)=" ","DNP",(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FAL SE)))

What I would like this to do is if there is nothing in the cell it should
put DNP and if there is the numbers 0,1,2,3,4 I want it to put those numbers
in the cell. Can you help me

Thank you Dwalston

when I put a number in the cell it is still putting the DNP ...

I'm confused. What exactly is this cell you are referring to?
A26? Or P1? Or the vlookup's table array?
Pl re-explain clearly your scenario
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

There's nothing wrong with your formula.

I'm betting that you're looking in the wrong column for the return value.

What's in P1?


--
Biff
Microsoft Excel MVP


"dwalston" wrote in message
...
Hi
when I put a number in the cell it is still putting the DNP on sheet in
stead of the number that is in the cell I only want the DNP when there is
nothing in the cell

Thank you for the help

"Max" wrote:

.. if there is nothing in the cell ..
I presume you are referring to the vlookup's return? Don't see anything
wrong with your formula per se. It could be a case of a white space
throwing
expected returns off (the white space in the cell will look like the
"nothing"). You could try wrapping a TRIM around the vlookup, like this:
=IF(TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$124,$P$1,FAL SE))="","DNP",TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$12 4,$P$1,FALSE)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dwalston" wrote:
I have this formula

=IF(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)=" ","DNP",(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FAL SE)))

What I would like this to do is if there is nothing in the cell it
should
put DNP and if there is the numbers 0,1,2,3,4 I want it to put those
numbers
in the cell. Can you help me

Thank you Dwalston