View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jshendel Jshendel is offline
external usenet poster
 
Posts: 24
Default finding cell location

A toughie...
I have a list in column 1 on sheet 1 that I am looking for it's cell
location on sheet 2.
However, on sheet 2, the range is B3:M494. It is not all in one column or
row, or then I would use vlookup or hlookup possibly....
I want an equation that finds the value on sheet 2 and returns the cell
location (B6, F67, M335, etc.)

Thanks,
Josh