if v lookup formula

[dwalston]

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,FALSE)))

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]

Doesn't your formula do that?

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,FALSE)))

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

 

[Max]

.. 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,FALSE))="","DNP",TRIM(VLOOKUP(A26,Tuesday!$A$5:$AC$124,$P$1,FALSE)))

 

[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]

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

 

[T. Valko]

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?