I want to use the hlookup function but the data I need to look up
has the lookup value at the bottom row rather than the top.

(Find a match in the bottom row and return the values in the same column
for the 10 rows above the lookup value).

Can this be done?

=Index(A1:J1,1,match(Value,A10:J10,0))

--
Regards,
Tom Ogilvy

"GEB" wrote in message
...
I want to use the hlookup function but the data I need to look up
has the lookup value at the bottom row rather than the top.

(Find a match in the bottom row and return the values in the same column
for the 10 rows above the lookup value).

Can this be done?

Tom,

This is what I was looking for.

Thanks.

"Tom Ogilvy" wrote:

=Index(A1:J1,1,match(Value,A10:J10,0))

--
Regards,
Tom Ogilvy

"GEB" wrote in message
...
I want to use the hlookup function but the data I need to look up
has the lookup value at the bottom row rather than the top.

(Find a match in the bottom row and return the values in the same column
for the 10 rows above the lookup value).

Can this be done?