How to correctly transfer the formula to the new version of Google Sheets?

Question

Google

When copying information from the old table to the new one, the function with selecting a value for a specific item from the drop-down list does not work. I have already broken my head, I don’t know what’s the matter ..
Here is a link to the source >

Answer 1

remove the semicolon after the last argument
=OFFSET($A$1;MATCH($D$1;$A:$A;0)-1;1)

Answer 2

Thank you, everything is working now