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

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