LOOKUP funciion giving an error

[Guest]

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

 

[Biff]

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

 

[Guest]

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 an #N/A I think because B2 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 continuously.

Thanks,
Mike

 

[Guest]

Thanks Biff, Works great.

Mike

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