VLOOKUP - avoiding left column rule

G

grphillips

Guys,

Any ideas how to avoid the left hand side of the page rule wit
VLOOKUP, I the lookup value must always been the left foremost column
Any ideas how to avoid this by using a formula within a vlookup.


Please illustrate clearly and explain reasons why it work?


Thanks in advance
 
M

mzehr

Hi,
You might want to try:
=INDEX(ReturnValueRange,MATCH(LookupValue,MatchValueRange,0))
This will allow you to lookup a value to the left.
 
B

Bill Martin

Any ideas how to avoid the left hand side of the page rule with
VLOOKUP, I the lookup value must always been the left foremost column.
Any ideas how to avoid this by using a formula within a vlookup.


Please illustrate clearly and explain reasons why it work?
Click to expand...

I just use LOOKUP in those cases. This allows you to search within one
column of your sheet and then find the corresponding number in another column
with no restrictions requiring the left column. The HELP file in Excel will
explain its use.

For example: =LOOKUP($E$4,I4:I200,A4:A200) will search the "I" column and
then fetch the corresponding result from the "A" column.

Good luck...

Bill -- (Remove KILLSPAM from my address to use it)
 
Top