Stefi, dont hate me, but i need 2 more things:

this is the most important..

if i don't write nothing (john) the formula 1 it's showing #N/A
i dont want formula to show me anything...until i write something in cell A
i mean the formula to work after i write "john"

and, if i write wrong "jonn" instead of "john", the formula to show me no
planning. the formula to have "yes", "no", and "no planning". (Like in the
second formula)

formula 1
=IF(VLOOKUP(IF(ISERROR(SEARCH("(",A2)),A2,TRIM(LEF T(A2,SEARCH("(",A2)-1))),PLANNING!A:B,2,FALSE)=TEXT(B2,"nnnn"),"YES"," NO")



and if there is a possibility "no planning" to appear written in red???
and if it is possible, i will need the same thing for this formula too:

formula 2
=IF(A8<"";IF(ISNA(VLOOKUP($A8;Sheet2!$J$1:$L$20;3 ;FALSE));no
planning;VLOOKUP($A8;Sheet2!$J$1:$L$20;3;FALSE));" "))

thanks.
and...thanks!

"puiuluipui" a scris:

It's working!
Thanks allot Stefi!
You are great! Thanks








"Stefi" a scris:


formula 1
=IF(VLOOKUP(IF(ISERROR(SEARCH("(",A2)),A2,TRIM(LEF T(A2,SEARCH("(",A2)-1))),planning!A:B,2,FALSE)=TEXT(B2,"nnnn"),"YES"," NO")

formula 2
=IF(A2<"",IF(ISNA(VLOOKUP(
IF(ISERROR(SEARCH("(",A2)),A2,TRIM(LEFT(A2,SEARCH( "(",A2)-1))),planning!$A$2:$C$20,3,FALSE)),0,
VLOOKUP(
IF(ISERROR(SEARCH("(",A2)),A2,TRIM(LEFT(A2,SEARCH( "(",A2)-1))),planning!$A$2:$C$20,3,FALSE)),"")

Regards,
Stefi