Thread: return the reference of a cell with certain text in it
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
  
Posts: 504
Default return the reference of a cell with certain text in it
Hello all,

I would like to find a formula that will search for the cell containing the
word "Doctor 1" and return the reference (location) of that cell (such as A1
or R1C1).

thanks
Reply With QuoteReply With Quote