Cross Referencing With More Than One Variable?

Hi,

Sorry for maybe not been clear enough originally. In the original spreadsheet (that I attached to the first post) - in the first worksheet ('No. of Comp Staff by Location') - the chart there. For someone to be fully compliant for that location they need to have completed all the courses with a 'yes' in that cell. Each 'yes' means that it's mandatory that that course is complete as well as all the other yes's in that row in order to be compliant for to work at that location.

I'd guess there is a way of using multiple IFs and LOOKUPs?

Hope this makes sense? Let me know if the table needs reformatting and I can work something out to make it easier to read.

Many thanks