V Lookup and return cell address

T

Thomas

I receive a huge spreadsheet from a vender each month. I'm trying to find a
client code in this spreadsheet listed somewhere in column A. After finding
the client code, I want the vlookup to return the cell address that the
client code is in (Ex. A9).

Thanks for the help,
Thomas
 
B

bpeltzer

vlookup will only return a piece of data that's in the table. Could you use
MATCH instead? If your match looks in a single column, it returns the row#
w/in the table where the match was found. So if you use
=match(a1,Sheet2!a:a,false), the return value will be the row number. You
could turn that into an address:
="A" & match(a1,Sheet2!a:a,false)
HTH. --Bruce
 
Top