Forum Discussion
Pull Data from another sheet if number matches
I'm wondering how to take the information from the Inv column in sheet 2 and add it to sheet 1 if the Loan number matches? I have 2 separate reports and need to add information to the ot...
In B2:
=XLOOKUP(A2, 'Sheet 2'!B:B, 'Sheet 2'!A:A, "")
Replace Sheet 2 with the real name of that sheet.
Fill down.
