RK0909,

Use a combination of functions

=INDEX(RowToPullDataFrom, MATCH(lookupvalue, lastrow, false))

HTH,
Bernie
MS Excel MVP


"rk0909" wrote in message
...
All,

I want to do a Hllookup. But instead of looking at the first row i want the
formula to look at the last row for referecne. Is it possible?

Any other solutions to this problem.

Thanks,

RK0909