Getting row reference number
 

Kindly advise me how to get the row reference number of data which VLOOKUP
function fetches.

Thanks

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

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