Its Pleasurer if you can support me to write function to preform google sheet.

Best regard Indika

CodePudding user response：

let me know if this is useful:

In D7 use this formula and copy then to the entire range:

=index('Facility Schedule'!$1:$962,match($C7,'Facility Schedule'!$B$1:$B$18,0) if($F$3="Actual",1,0),match(D$6,'Facility Schedule'!$2:$2,0))

Here I upload a picture of your own spreadsheet with Plan and Actual displayed: Look how Facility A changes (which is the only one different by now)