| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is vlookup with an inverted start point possible?
I'm using 2007 exel and the vlookup function seems to be what I
need....Almost. I have a growing list of numbers, curently with over 1000 rows. I want to lookup a number in column E and get the corresponding number in column L, my range is E2:L1011. When I set up a vlookup it finds the number 150 no problem however it starts looking at the top of the range at E2. I want the function to start at E1011 and work its way up so I get the most recent entry. Any Ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to evenly increment between start point and end poi | Excel Discussion (Misc queries) | |||
| VLookup (possible to point to a range) | Excel Discussion (Misc queries) | |||
| can I pick start point in a range? | Excel Discussion (Misc queries) | |||
| How do I use vlookup to point to an external file that changes nam | Excel Worksheet Functions | |||
| how do I chang the start point for my next row? | Charts and Charting in Excel | |||
Threaded Mode
