#N/A

[puiuluipui]

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.

 

[Bob Phillips]

=IF(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]

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:

 

[Bob Phillips]

=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]

its working, but if i write something, and than i delete it, the formula its
still working and display "no day". i closed excel and open it again, but...
"no day its still showing. the cell are empty, but......the formula its
showing "no day"

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

anyway, its working.
if you can help me with yhis one, i will be very glad. if not, thanks anyway
you helped me allot.
thanks

"Bob Phillips" a scris: