=IF(OR(B1="",ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE) )),"",IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1; "dddd");"YES";"NO"))


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"puiuluipui" wrote in message
...
Its working, but when i write something in cell A, the formula show me
"no",even i didn't write anything in B cell. I want the formula to show
the
result only after i write in both cells, A and B.

Thanks allot.

"Bob Phillips" a scris:

=IF(ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE)),"",IF(V LOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd");"Y ES";"NO"))


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"puiuluipui" wrote in message
...
The formula show me #N/A if i dont write anything in A2 OR E2.
I want the formula to work just after i write something in A2 or E2, or
in
both cells.

And .....can formula to show me "no day" if i write something wrong in
cell
A2 or E2, or if the formula doesn't find correct data in PLANNING!...?
The
formula to give me "yes" or "no" if everithing its ok, and "no day" if
something its wrong. The formula to have "yes", "no" and "no day".

This is the formula:
=IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd ");"YES";"NO")


my table

a B E PLANNING! B
C

1 JOHN 02.06.2008 YES JOHN MONDAY
2 JOHN 01.06.2008 NO
3 JON 02.06.2008 no day
.................................................. .misstype
4
..........................................nothing written

And, if i dont ask too much, can the formula show "no day" in red????
Thanks in advance.
Thanks.