ExcelBanter - VLOOKUP and OFFSET

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP and OFFSET (https://www.excelbanter.com/excel-worksheet-functions/150736-vlookup-offset.html)

VLOOKUP and OFFSET

I need to return data on one spreadsheet that is two rows above, and 10
columns accross, from the data that I want to base the search on. I intended
to use a combination of a lookup and an offset command, but have so far been
unable.

Is this possible, or is there an alternative solution?

Peo Sjoblom

VLOOKUP and OFFSET

=INDEX(J1:J100,MATCH(Lookup_Value,A1:A100,0)-2)

Of course this will give you problems if the lookup value is in row 2 or
above

--
Regards,

Peo Sjoblom

"PJ" wrote in message
...
I need to return data on one spreadsheet that is two rows above, and 10
columns accross, from the data that I want to base the search on. I
intended
to use a combination of a lookup and an offset command, but have so far
been
unable.

Is this possible, or is there an alternative solution?

Mike H

VLOOKUP and OFFSET

Perhaps,

=LOOKUP(A1,A10:A30,K8:K28)

Mike

"PJ" wrote:

I need to return data on one spreadsheet that is two rows above, and 10
columns accross, from the data that I want to base the search on. I intended
to use a combination of a lookup and an offset command, but have so far been
unable.

Is this possible, or is there an alternative solution?

All times are GMT +1. The time now is 08:46 PM.