Compare if conditions are met.

[jhonneyboy]

Hi, I've been struggling for a while with something I can't seem to fix.

I've added the example as an attachment.

The problem I have is:
I have two different tables, 1 table gives the conditions you need for specific stations. Stations is shown vertically (10 to 150), and conditions people must have are shown in the top row. (Alphabet). This data is given and can change alot. If I compare this data, a new table will be created that compares the conditions per station with the people if they have it too. Then it will need to give an answer, 'Yes or 'No''. Yes means he has met all the conditions needed, so has all the competences needed for the station.

I tried to do this with normal formulas, but no succes. I can do it by doing like 100 IF's in 1 formula, but that isn't efficiënt.

Also I have done a formula IF(SUM(IF(Competentions!$D$21:$BT$21=Competention!$D10:$BT10,0,1))=0,"x",""), but that only compares if the person has exact the same competences, if he has more then the needed on 1 location, a NO will be returned. Same with count, that doesn't work either, if he has the same amount of competences needed for example station 10, he is allowed to, but he doesnt have the competences that are needed for that station..


Can someone help me with a macro or some other way around this?

Thanks in advance,
Gr Jhonneyboy