Is there a way to get the data at the intersection of a column that meets a criteria using Index:Match and a row that meets criteria using Index:Match?
For instance, if my data is:
John Jim Kelly Sept 0 0 10 Oct 10 0 0 Nov 0 10 0
How can I use an Index:Match combination to get the value at the intersection of Jim and Nov? Keeping in mind that my data is a bit more complicated than this, the table has 20+ rows and 10+ columns.
Bookmarks