need vlookup function to return the row number

Giganews Newsgroups
Subject: need vlookup function to return the row number
Posted by:  skiing (trpay…@chatt.com)
Date: Wed, 9 Jul 2008

I have a one column list of data (around 3,000 items) - and I am using
the vlookup function to determine if an item is in that list using
something like the formula below:

=if(iserror(vlookup(A1,D1:D3000,1,false)),"not in list","in list")

I would like to know if I can have this function return the cell
address or row number to indicate the location of the item in the list
- is this possible?

Thank you for your time and assistance

Replies