Connect two worksheets

[Aurora21412]

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

[#2 · Accepted solution]

@Aurora21412 

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.

[#3]

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, "")