Forum Discussion
Matching cell values on 2 criteria
I have two separate sets of data that I'm trying to combine in to one. Sheet 1 has one row per person, and multiple columns for each of their responses to a question. Sheet 2 has multiple rows for ea...
=IFERROR(INDEX(Sheet2!$C$1:$C$100,MATCH(1,(Sheet1!$A2=Sheet2!$A$1:$A$100)*(Sheet1!B$1=Sheet2!$B$1:$B$100),0)),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.