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.

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.