if v lookup formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dwalston - 24 Mar 2008 02:04 GMT

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

Reply to this Message

Dave Peterson - 24 Mar 2008 02:57 GMT

Doesn't your formula do that?

> I have this formula
>
[quoted text clipped - 5 lines]
>
> Thank you Dwalston

Signature

Dave Peterson

Reply to this Message

Max - 24 Mar 2008 02:59 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I have this formula
>
[quoted text clipped - 5 lines]
>
> Thank you Dwalston

Reply to this Message

dwalston - 24 Mar 2008 04:59 GMT

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

> > .. if there is nothing in the cell ..
> I presume you are referring to the vlookup's return? Don't see anything
[quoted text clipped - 11 lines]
> >
> > Thank you Dwalston

Reply to this Message

Max - 24 Mar 2008 05:16 GMT

> 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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

T. Valko - 24 Mar 2008 05:46 GMT

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?

Signature

Biff
Microsoft Excel MVP

> Hi
> when I put a number in the cell it is still putting the DNP on sheet in
[quoted text clipped - 21 lines]
>> >
>> > Thank you Dwalston

Reply to this Message