Forum Discussion
Solved
Connect two worksheets
When I type the ‘Address’ on my ”2023” sheet, I want the ‘Superintendent’ and the ‘SQFT’ to automatically fill based on what I have on the “Santa Rita 45” sheet
In E2 on the 2023 sheet:
=XLOOKUP(F2, 'Santa Rita 45'!A:A, 'Santa Rita;!B:B, "")
Fill down.
In I2:
=XLOOKUP(F2, 'Santa Rita 45'!A:A, 'Santa Rita;!C:C, "")
Fill down.
In E2 on the 2023 sheet:
=XLOOKUP(F2, 'Santa Rita 45'!A:A, 'Santa Rita;!B:B, "")
Fill down.
In I2:
=XLOOKUP(F2, 'Santa Rita 45'!A:A, 'Santa Rita;!C:C, "")
Fill down.
Thank you SO much! You just made my life so much easier! I had to tweak it a bit in order for the formula to work but basically just a spelling error.
= XLOOKUP(F2, 'Santa Rita 45'!A:A, 'Santa Rita 45’!B:B, "")
= XLOOKUP(F2, 'Santa Rita 45'!A:A, 'Santa Rita 45’!B:B, "")