P
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.
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.