excel lookup returning reference

Question

Excel has a "lookup" function that finds a specified value in a row or column and returns a corresponding value from another column.

But is there a lookup that returns the reference of the found cell? I have a case where I have a column of dates, and I want to search the list for a given date and then return the reference -- A23 or whatever -- of that cell.

Answer 1

I believe you're looking for the Find method in VBA?

.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat)

http://msdn.microsoft.com/en-us/library/aa195730(office.11).aspx