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])
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])