My code populates names of employees that can work Sunday's.
However, I have another column in my table which has skills (i.e. Banking CCTV Clients Driving). etc.
I want to add a condition so that my code below will also check if the person who's available on Sunday has the skills in J2 (say J2 is "Driving").
This works fine:
This does not:
However, I have another column in my table which has skills (i.e. Banking CCTV Clients Driving). etc.
I want to add a condition so that my code below will also check if the person who's available on Sunday has the skills in J2 (say J2 is "Driving").
This works fine:
Code:
=INDEX(Jobs,SMALL(IF(Jobs[Sun]="yes",ROW(Jobs[Employee])),ROW(1:1))-1,1)This does not:
Code:
=INDEX(Jobs,SMALL(IF((Jobs[Sun]="yes")*([B]Jobs[Skills]=search(J2,,),[/B]ROW(Jobs[Employee])),ROW(1:1))-1,1)
