2 level dependant dropdown lists

[Luis_Gomes_Mac1]

Hi everyone I have the following table and I need to fill another table pulling data from this one.
I use:
first column
Attendance[Attendance Category]

second column
Attendance[Attendance Type]

so they can de-ref
I need to fill up another third column as:
Attendance[Attendance]

but I get a N/a result

Can someone help how to do a 3 level de-ref?