| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page# Return off lookup
I'm building a table of contents for a parts catalog and would like to the
page number returned off a lookup through a specific column. As I would see it, the lookup would be somethink like this: (car type would be in TOC) vlookup([Car Type],F2:f25000,PageNumber()) I have a problem with getting the PageNumber the item falls on to be returned. Any ideas? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup and return value | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Lookup and return | Excel Worksheet Functions | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
| Lookup from first row, return last row value | Excel Programming | |||
Threaded Mode
