Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Number of VLOOKUP result
I am wanting to know the row number in which a VLOOKUP result was found. I
know I could have a column containing the row number, and return that as my result, but that could lead to a good bit of other editing if I add such a column to an already fairly well developed spreadsheet; I would just like to avoid that option if I can. Please offer help in either function calls and/or VBA macro - I am comfortable with either or. I would cross post in Programming too, but Daniel has told us that this frowned on, and I don't know the USENET designation anyway - I wonder why they even offer the option, when it is so difficult to find the necessary information to do so, eh. Best regards Philip Hunt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#n/a result for vlookup | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
VLOOKUP - Can't see result | Excel Worksheet Functions | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions |