vlookup Sorry if it's confusing..

[roger r]

I need help with a vlookup problem. Here's the best
example I can give to my problem:

Sheet # 1
A B C D
1 25 vlookup(A1,E1:H1,4,0)
I want to retrieve info in colums H-J
2 26 using the reference in colums E-G

3 27 I would thing the formula would look
something like =vlookup(A1,E1:J1,4-6,0)
but that doesn't work.

Lookup Sheet.

------ set 1------ ------set 2-------
e f g h i j
1 25 26 27 1 2 3


2 28 29 30 4 5 6


3


4

 

[George King]

Vlookup (and Hlookup) will only return one value.
Using your example, the lookup range - E1:H1 (usually
several rows) will return the value in the 4th column - H
in this case.

You description sounds like you're trying to return
multiple values or a sum?

 

[Alan Beban]

Vlookup (and Hlookup) will only return one value.

=VLOOKUP(lookup_value, lookup_table,{3,4,5}, False), array entered, will
return the corresponding values from the 3rd, 4th and 5th columns of the
lookup table.

Alan Beban