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