=IF(Lookup Problem

[artistry]

hi guys,

i'm new on this forum and new to excel formulas as well, i've been trying to make this simple worksheet using a =IF(Lookup formula to display when specific people are working or are on their days off.

by changing the days specified on cell C8 to display the persons name if they're working that day, or the text "day off" if they aren't.

but somehow whenever i type in "thu" or "fri" most of the results displayed are showing up as "#N/A"

i'm going to include here the actual file is anyone is able to help me, as i can't seem to work it out for the life of me. (download)

by the way, the formula i'm using is:

=IF(LOOKUP($C$8;E9:K9)=$C$8;"day off";E9)

thank you in advance

 

[snoopyhr]

or modify your formula as:
=IF(ISERROR(IF(LOOKUP($C$8,E9:K9)=$C$8,"day off",D9)),"",(IF(LOOKUP($C$8,E9:K9)=$C$8,"day off",D9)))

it is sort of error trapping , if n/a not desired

 

[T. Valko]

thanks guys, seem to finally have been able to get it to work, thanks to T. Valko's formula this was really doing my head in...

You're welcome. Thanks for the feedback!