XLOOKUP based on result of previous XLOOKUP

[Fester675]

I'm using 2 data tables with "disability conditions". I need to populate a third table with a combined result of the other 2
Table 1 columns = Ref1 + Condition1
Table 2 columns = Ref2 + Condition2
Table 3 columns = User No. + Condition + Correct Condition

=XLOOKUP(Table3[@Condition],Table1[Condition1],Table1[Ref1])
gives result of #1-19

then I need the result (#1-19) as start of next formula...

=XLOOKUP(Table1[Ref1],Table2[Ref2],Table2[Condition2])

 

[Skovgaard]

Not sure I understand, but what about =XLOOKUP(XLOOKUP(Table3[@Condition],Table1[Condition1],Table1[Ref1]),....)??

/Skovgaard