I have two worksheets within a workbook.
I am looking for a way to use a formula on Worksheet to get a cell reference on Worksheet 2 for a cell that contains a specific datapoint.
What can I use that would analyze a range of cells to find this answer?
See attached workbook example
Bookmarks