Ok I have a question for you knowledgeable people out there.

I need a if statment that basicly reads as follows

If the cell is #n/a then "Not Logged" or,

If the cell is 1/00/00 then "Evaluation or,

If the cell is #n/a, and there is a number in the cell prior then
"Received"

but my problem is that i am using a vlookup function in that cell also,
here is what I have so far
"=IF(VLOOKUP(C4,Outstanding!C3:M1001,11,FALSE),ISN A(AH4),"RECEIVED")" I
was trying this just to see if I could get that cell to say received but
it will not go. I know that I need to add another part to this IF to
look at the cell prior to look for a number so it shows received.

I am going out of my mind. Is there anyone that can help me.


--
Hexabah
------------------------------------------------------------------------
Hexabah's Profile: http://www.excelforum.com/member.php...o&userid=16040
View this thread: http://www.excelforum.com/showthread...hreadid=274987

Hi

try
=IF(AND(ISNA(VLOOKUP(C4,Outstanding!C3:M1001,11,0) ),ISNUMBER(AH4)),"Received",IF(ISNA(VLOOKUP(C4,Out standing!C3:M1001,11,0)),"Not
Logged",IF(VLOOKUP(C4,Outstanding!C3:M1001,11,0)=" 1/00/00","Evaluation","Something
Else")))

Hope this helps
Cheers
JulieD


"Hexabah" wrote in message
...

Ok I have a question for you knowledgeable people out there.

I need a if statment that basicly reads as follows

If the cell is #n/a then "Not Logged" or,

If the cell is 1/00/00 then "Evaluation or,

If the cell is #n/a, and there is a number in the cell prior then
"Received"

but my problem is that i am using a vlookup function in that cell also,
here is what I have so far
"=IF(VLOOKUP(C4,Outstanding!C3:M1001,11,FALSE),ISN A(AH4),"RECEIVED")" I
was trying this just to see if I could get that cell to say received but
it will not go. I know that I need to add another part to this IF to
look at the cell prior to look for a number so it shows received.

I am going out of my mind. Is there anyone that can help me.


--
Hexabah
------------------------------------------------------------------------
Hexabah's Profile:
http://www.excelforum.com/member.php...o&userid=16040
View this thread: http://www.excelforum.com/showthread...hreadid=274987