Cross Referencing With More Than One Variable?

Hi guys

Firstly, could anyone let me know if what I'm trying to achieve is possible? And if so could you help advise what method or formulas I could use. Any suggestions at all would be appreciated!

I've attached a copy of the spreadsheet I'm working on. I'm struggling to work out the best way to get the information in column G ('No. of fully compliant staff') located in the 'No. of Comp Staff by Location' worksheet.

Columns A:C in the 'Testing Method 1' worksheet is the raw data. Columns D onward in this tab are what I've done so far in hopes of finding an easier way to get the result but I think it's a dead-end really.

It's only a problem because in the raw data we have the 'employee number' each time they complete a course. Perhaps I should start by trying to get all data relating to that employee onto one row? Is there a formula for this?

Sorry it's not the easiest question in the world but I'm really struggling!

Again any help would be appreciated.

Cheers

Harry