Hi all, first time posting here. I've been creating a football (soccer) database using pivot table, vlookup and index & match.
All has been going well, but i've come to a stumbling block, I need to find the "missing" players from a match day 11+subs. Fig 1 shows the starting 11 and subs and the relevant data i've used using the terms above. I've had a trouble wording this query into google (and on here).
Fig 1.
Fig1.jpeg
(I've another table which gets rid of the #ref's)
Fig 2 shows the squad list for 2016 which is on another sheet, so I essentially want a table or range under fig. 1 which shows the players and their stats who aren't in the 11+subs.
Fig 2.
Fig 2.jpeg
Any help would be fab
Cheers,
Jake
Bookmarks