SOLVED

Connect two worksheets

Copper Contributor

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

2 Replies
best response confirmed by Aurora21412 (Copper Contributor)
Solution

Re: Connect two worksheets

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.

Re: Connect two worksheets

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, "")
1 best response

Accepted Solutions
best response confirmed by Aurora21412 (Copper Contributor)
Solution

Re: Connect two worksheets

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.