lookup value from reference table

Hello,

I want to create a new table that has a column which lookups and returns each value at each level from lookup table.

Is there a solution for this?

Thanks a lot

this is the output I am looking for

my result(not correct)

Thank you