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 a...