Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup help
I am attempting to use this command
=LOOKUP(H7644,$A1:$A7643,$B1:$B7643)&" WITH E D/G BACKUP" in order to return a necessary result. When H7644 is entered as text or a number, the return yields what I want. If H7644 contains something like =MID(A7644,1,LEN(A7644)-2), nothing happens. I'm assuming this needs to be a named range or something? I need this to encompass another 500 rows or so (the $A1:$A7643,$B1:$B7643 range will stay the same, just the H cell reference will increase by an increment for each additional row). Anyone have any idea how to get this to work? I'm using Excel 2003. Thanks in advance. |
#2
|
|||
|
|||
It should work.
if your "=MID(A7644,1,LEN(A7644)-2)" actually matchs anything in the A1 to A7643. If it looks like it does, say at A6000, in some cell enter =(A6000 =A7644) A "false" would indicate there may be a character which does not show that makes it unequal. "MAB" wrote: I am attempting to use this command =LOOKUP(H7644,$A1:$A7643,$B1:$B7643)&" WITH E D/G BACKUP" in order to return a necessary result. When H7644 is entered as text or a number, the return yields what I want. If H7644 contains something like =MID(A7644,1,LEN(A7644)-2), nothing happens. I'm assuming this needs to be a named range or something? I need this to encompass another 500 rows or so (the $A1:$A7643,$B1:$B7643 range will stay the same, just the H cell reference will increase by an increment for each additional row). Anyone have any idea how to get this to work? I'm using Excel 2003. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |