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