I have two sheets. The Coordinator sheet is like a master file and cell B7 to CM26 has a conditional formatting that I want to populate on the Consultant sheet.

Coordinator sheet – master file

If say on the Consultant sheet – coordinator C1 is selected, I want the ‘V with green fill’ be populated on the matching dates:

FYI – column A in Consultant sheet is a dropdown of the list of coordinators in the Coordinator Sheet

I use this formula but its giving me the #N/A error:

=INDEX(Coordinators!$B$7:$CM$26,MATCH(Consultant!B11,Coordinators!$B$6:$CM$6,0),MATCH(Consultant!$A$12,Coordinators!$A$7:$A$26,0))

You’re assistance is greatly appreciated!

​I have two sheets. The Coordinator sheet is like a master file and cell B7 to CM26 has a conditional formatting that I want to populate on the Consultant sheet. Coordinator sheet – master file If say on the Consultant sheet – coordinator C1 is selected, I want the ‘V with green fill’ be populated on the matching dates: FYI – column A in Consultant sheet is a dropdown of the list of coordinators in the Coordinator Sheet I use this formula but its giving me the #N/A error: =INDEX(Coordinators!$B$7:$CM$26,MATCH(Consultant!B11,Coordinators!$B$6:$CM$6,0),MATCH(Consultant!$A$12,Coordinators!$A$7:$A$26,0))  You’re assistance is greatly appreciated!    Read More

​