Forum Discussion
How can i merge three xlook ups into one formula
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)
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)
- That returns #N/A unfortunately
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?
