I am trying to write a formula that will return the value in the cell that is the intersection of a row and column that is referenced.
Almost like using INDEX but instead of defining the row and column I want the formula to search through the rows and columns and pick the row and column that I am referencing and then return the value where that row and column intersect.
Any ideas?
Bookmarks