If's and Isna's and stuff

[Hexabah]

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),ISNA(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.

 

[JulieD]

Hi

try
=IF(AND(ISNA(VLOOKUP(C4,Outstanding!C3:M1001,11,0)),ISNUMBER(AH4)),"Received",IF(ISNA(VLOOKUP(C4,Outstanding!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