ExcelBanter - Vlookup - return row no. instead of value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup - return row no. instead of value (https://www.excelbanter.com/excel-discussion-misc-queries/16353-vlookup-return-row-no-instead-value.html)

automne

Vlookup - return row no. instead of value

Dear all,

For vlookup, it will return the value of the destination cell. Is it
possible to return the row no. instead of value of the destination cell??

Your help is highly appreciated.

Thanks & regards,
Automne

Myrna Larson

Look at the MATCH function in Help.

On Sat, 5 Mar 2005 01:41:39 +0800, "automne"
wrote:

Dear all,

For vlookup, it will return the value of the destination cell. Is it
possible to return the row no. instead of value of the destination cell??

Your help is highly appreciated.

Thanks & regards,
Automne

budgie

On Sun, 06 Mar 2005 17:35:16 -0600, Myrna Larson
wrote:

Look at the MATCH function in Help.

or add another column with the row number in it ...

On Sat, 5 Mar 2005 01:41:39 +0800, "automne"
wrote:

Dear all,

For vlookup, it will return the value of the destination cell. Is it
possible to return the row no. instead of value of the destination cell??

Your help is highly appreciated.

Thanks & regards,
Automne

All times are GMT +1. The time now is 06:43 PM.