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?

=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?

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?