|
| 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
September 16th, 2003, 09:16 PM
|
|||
|
|||
Vlookup or Match/Index to return value 2 rows down
I have a spreadsheet where my lookup value is not listed
in every row as it is just listed once like a header. Is there a way to create a formula to lookup a value but return the value 4 rows down? Any help would be appreciated. 
|
|
#2
September 16th, 2003, 09:37 PM
|
|||
|
|||
|
Vlookup or Match/Index to return value 2 rows down
Use HLOOKUP.
Alan Beban Donna wrote: I have a spreadsheet where my lookup value is not listed in every row as it is just listed once like a header. Is there a way to create a formula to lookup a value but return the value 4 rows down? Any help would be appreciated.
|
|
#3
September 16th, 2003, 09:43 PM
|
|||
|
|||
|
Vlookup or Match/Index to return value 2 rows down
It looks like you want...
=INDEX(A5:E5,MATCH(LookupValue,A1:E1,0)) Have also a look at HLOOKUP. "Donna" wrote in message ... I have a spreadsheet where my lookup value is not listed in every row as it is just listed once like a header. Is there a way to create a formula to lookup a value but return the value 4 rows down? Any help would be appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
