Hello Everybody, Your assistance is required.
In the enclosed spreadsheet is a very simplified version of something I am trying to achieve.
I would like to select the name and the year on the (Data) sheet and then have it fill out the relevant information in the columns below. I've done something similar using INDEX & MATCH. But because the information can change depending on the sheet, I'm not sure how to go about this. The columns on each sheet are the same and not going to move.
As I said the example is a simplified version, the real sheet is huge but the premise is the same. I will then use this information to provide various bits on information. I can do that part, it's getting the date required I am struggling with.
Bookmarks