Yes sorry, I put the wrong column number for the index function, it should have been column 2 for what I was saying, not 3.
Basically this lookup problem is made overly complicated by the design layout, the problems are....
1. You are looking up from table headers that contain merged cells, and the actual data you want is in multiple columns below that in some cases.
2. Not all table header look ups exist on the same row.
3. The output values are 3 completely different data formats.
Have a look at what I have done to this now, I unmerged the cells for the table headers, you could put loads of spaces in front to get them to the middle for the purpose of the appearance. I added the 'Overll Wn %' column header in E2, and 'Tourney App.' in B2 on the Seed Stats sheet, so that all the drop down list lookup values exist on the same row. I made B2 on the Summary sheet into a dropdown list using your range E4-E6 on that sheet.
Then accounted for the different formats to return data in, by using this rather long formula in C5 on the summary sheet.
Bookmarks