可以簡單使用 apps scripts 達成想要的效果
試算表 → 擴充功能 → Apps Script

第一次使用Apps Script如果出現cookie相關錯誤，可能要先清理cookie

function updateCellValue() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var cellA9 = sheet.getRange("A9");
  var rangeA1toA7 = sheet.getRange("A1:A7").getValues();
  var ranges = {
    "C1:C7": "C9",
    "D1:D7": "D9",
    "E1:E7": "E9"
  };

  for (var range in ranges) {
    var currentRange = sheet.getRange(range).getValues();
    if (arraysAreEqual(rangeA1toA7, currentRange)) {
      cellA9.setValue(sheet.getRange(ranges[range]).getValue());
      return; // Exit the loop if a match is found
    }
  }
}

function arraysAreEqual(arr1, arr2) {
  for (var i = 0; i < arr1.length; i++) {
      if (arr1[i][0] !== arr2[i][0]) {
        return false;
      }
    }
  return true;
}

F1:
=TEXTJOIN(",",,IF(C3:E3=A3,$C$9:$E$9,""))
向下複製到F2:F7儲存格。