Lookup question

R

rk0909

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
 
B

Bernie Deitrick

RK0909,

Use a combination of functions

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

HTH,
Bernie
MS Excel MVP
 
Top