lookup value from reference table

[topazz11]

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

[AlexisOlson · Accepted solution]

Why do some names have null rows and others do not?