Vlookup - return row no. instead of value

[automne]

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.

 

[budgie]

Look at the MATCH function in Help.

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