Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup problem | Excel Worksheet Functions | |||
Help using lookup function | Excel Discussion (Misc queries) | |||
Lookup Type Question | Excel Worksheet Functions | |||
Formula Question... LookUP | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions |