In the attached spread sheet I would like to get the answer '1' in Sheet2, cell B15.
I have put in an INDEX, MATCH, MATCH, MATCH formula that returns a #N/A error.
Would someone be so kind as to correct my formula so the desired result is returned?
In the formula I need to know the Division (1) a particular team (Clayton) was in at RAN (10) in 1974.
I used the INDEX as the Division and the other 3 pieces of information as the MATCHES.
Thank you for any assistance and advice you can offer.
Sample1.xlsx
Bookmarks