Match Multiple Values with Multiple Values from Another Table - Return a Single Value

Hi,

try this one:

Formula:

=IFERROR(OFFSET($B$24;MATCH($B4;$B$25:$B$33;0);MATCH(YEAR(C$3);$C$24:$J$24;0);1;1);"Element not found")

Test booklet.xlsx

Regards

M