What I want is if Location and Case Number line up on Sheet1 and Sheet2, add in the Attorney information from Sheet2 to Sheet1. Here's a sample of the kind of data I'm dealing with:

CodePudding user response：

Thanks to u/findwindow, this is solved!

=INDEX(Sheet2!F:F,MATCH(A2&B2,Sheet2!A:A&Sheet2!B:B,0))

In my case, Sheet2 is called Attorneys, and I have headers so I skipped all of row 1.