VBA MSGBOX displaying Multiple Value VLOOKUP

[David_Sands]

Hi everyone,
Hope someone can help me with this ... I'm trying to work out how to do what is displayed in the image below. The table (cells C9:AB28) are all COUNTIFS based on data on a different worksheet (see the 2nd image below) in the same workbook and when the user clicks on one of the cells (for example I've clicked on Q23 below) a MSGBOX pops up showing all the student names behind the number 17 - or in other words all the people in column D (2nd image below) who match the matrix criteria in the first image below (in this example KS3 Sub-Level 5C and KS2 Sub-Level 5C).
Really hope someone can help me with this and many thanks in advance,
Dave

 

[saltkev]

Hi

because of restrictions placed on my Internet access I will have problems viewing your file. If you could send me a copy of the file containing dummy data along with what you are trying to achieve I will give it a look. May not be until Monday now.

kevin.eames@airbus.com

regards

Kevin