2D modelling, take value from reference table

Dear DNA team,

Would you mind helping me out for below scenario as I wanted to retrieve the value from the reference table seems array in excel,
There are multiple way to proceed in excel such as xlookup, etc.

However I would like to link the value from reference table to the working table.
2D modelling.pbix (32.4 KB)
scenario.xlsx (11.0 KB)