Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting row reference number
Kindly advise me how to get the row reference number of data which VLOOKUP
function fetches. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting row reference number
If you use the MATCH function, instead of the VLOOKUP function, it returns
the row_index of the searched range. Example: if you have A, B, C in cells A11:A13 and you use =MATCH("C",A11:A13,1) that formula will return 3 (because A is the 3rd item in the list. To get the actual row number, use: =MATCH("C",A11:A13,1)+10 (because you need to add in the number of rows above cell A11) Does that help? *********** Regards, Ron "Mahendhra" wrote: Kindly advise me how to get the row reference number of data which VLOOKUP function fetches. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting row reference number
Thanks! it helped me.
"Ron Coderre" wrote: If you use the MATCH function, instead of the VLOOKUP function, it returns the row_index of the searched range. Example: if you have A, B, C in cells A11:A13 and you use =MATCH("C",A11:A13,1) that formula will return 3 (because A is the 3rd item in the list. To get the actual row number, use: =MATCH("C",A11:A13,1)+10 (because you need to add in the number of rows above cell A11) Does that help? *********** Regards, Ron "Mahendhra" wrote: Kindly advise me how to get the row reference number of data which VLOOKUP function fetches. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master invoice number | Excel Worksheet Functions | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
return the column reference number of a function result | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |