Hi!
You're right, the value in B2 is a number that's formatted to display as
Tuesday.
=LOOKUP(TEXT(B2,"ddddd"),C7:I7,C8:I8)
Biff
"Mike K" wrote in message
...
Oh wise ones,
I think I know why it's in error (#n/a) I just don't
know how to fix it.
I have the following in their respective cells:
=NOW() in B2 with custom format ddddd
Monday Tuesday Wednesday ect in C7:I7 format text
A C C A A C C in C8:I8 format text
The formula in E2 is =LOOKUP(B2,C7:I7,C8:I8)
So B2 shows Tuesday and should find Tuesday in D7 and return C from D8 but
I
get a #N/A I think because A2 is really a value and not text. So how can I
get it to ignore the value and evaluate it as text? I need to keep it
dynamic, it will be updating continuesly.
Thanks,
Mike
|