Getting row reference number

M

Mahendhra

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

Thanks
 
R

Ron Coderre

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
 
M

Mahendhra

Thanks! it helped me.



Ron Coderre said:
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
Click to expand...
 
Top