I am trying to return the cell reference to be used in an offset function by
looking up the cell based on a specific value. eg. I have a cell with a date
in it on sheet 1. On sheet 2. I have a database of information in which one
column contains dates. I want to use the value of the date on sheet 1 to
find the cell reference with the same value on sheet 2. I will then use that
cell reference in a offset function to return the value of an adjoining cell.
How do I find the cell reference.