引継ぎメモ 中市
I列に =IF(ISNUMBER(MATCH(TRUE, ISNUMBER(SEARCH(","&D2&",", ","&$H$2:$H$9&",")), 0)), TEXTJOIN(",", TRUE, IF(ISNUMBER(SEARCH(","&D2&",", ","&$H$2:$H$9&",")), $D$2:$D$9, "")), "999999")