HLookUp

[Guest]

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 Ogilvy]

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

 

[Guest]

Tom,

This is what I was looking for.

Thanks.

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