Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LOOKUP funciion giving an error
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Thanks Biff, Works great.
Mike "Biff" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function Error | Excel Worksheet Functions | |||
excell 2000 is giving an error "not enough memory" | Excel Discussion (Misc queries) | |||
Excel help giving runtime error | Excel Discussion (Misc queries) | |||
Vlookup & Lookup function error | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |