If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup Sorry if it's confusing..
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 |
#2
|
|||
|
|||
vlookup Sorry if it's confusing..
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? -----Original Message----- 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 . |
#3
|
|||
|
|||
vlookup Sorry if it's confusing..
George King wrote:
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 |
Thread Tools | |
Display Modes | |
|
|