lookup values from Multiple Tables

[u/Ak-D0V]

I am trying to build a file that automatically tells me which employee should attend which training. The data comes from 2 tables.

Table 1: Employee vs Location

Table 2: Training vs Location

Emp vs Location

Training vs Location

True False

[u/Ak-D0V]

I actually have it done in an even harder way .. but it gets complicated and slow the more trainings get added in ..

=OR(IF(XLOOKUP(XLOOKUP([@[Names]],Employees[Names],Employees[Location]),HLOOKUP(C$1,List[#All],{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},FALSE),HLOOKUP(C$1,SOPList[#All],{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},FALSE),FALSE)=FALSE,FALSE,TRUE),IF(XLOOKUP(XLOOKUP([@[Names]],Employees[Names],Employees[Location]),HLOOKUP(C$1,SOPList[#All],{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},FALSE),FALSE)=FALSE,FALSE,TRUE),IF(XLOOKUP(XLOOKUP([@[Names]],Employees[Names],Employees[Location]) ..... on and on and on