8 野に咲く名無し@転載禁止 2025/05/20 (火) 08:59:25.504 ID:M9KN5XUL0
=VLOOKUP(INDIRECT("'" & "Sheet1" & "'!" & ADDRESS(ROW(OFFSET(Sheet1!A1, MATCH("キー", Sheet1!B:B, 0)-1, 0)), COLUMN(OFFSET(Sheet1!A1, 0, MATCH("ID", Sheet1!1:1, 0)-1)))), Sheet1!D2:G100, MATCH("出力項目", Sheet1!D1:G1, 0), FALSE)