VLOOKUP in Power BI

Hello, Maybe someone can help me with my problem.

I have two tables (values, key). In the table values there are several columns with different values. The table key shows which column must be used for the row. The remaining values are irrelevant (see picture). This value should be in a separate field. In Excel we have a VLOOKUP formula for this. It's a little complicated to explain, but I hope you understand it anyway.

Thank you for your help

table value