if v lookup formula

D

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
 
D

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
 
M

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)))
 
D

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
 
M

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top