How can i merge three xlook ups into one formula

[RyanExcels]

If i use three different xlook ups in 3 different columns i can get my result. But i want to do this in one cell using one formula. 

How do i merge these formulas? Each formulas look up will rely on the previous look up result 

=XLOOKUP(B2,Property!X:X,Property!B:B,,0)

=XLOOKUP(C2,Master!B:B,Master!AA:AA,,0)

=XLOOKUP(D2,Tenants!D:D,Tenants!AG:AG,,0)

[#2]

@RyanExcels 

Does this do what you want?

=XLOOKUP(XLOOKUP(XLOOKUP(B2,Property!X:X,Property!B:B,,0),Master!B:B,Master!AA:AA,,0),Tenants!D:D,Tenants!AG:AG,,0)

[#3]

That returns #N/A unfortunately

[#4]

@RyanExcels 

Which cells contain the formulas in your first post?

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?