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