Forum Discussion
Excel Formula Multiple Criteria Lookup
I need a formula that says if this value in column A Sheet 1 equals a value in Column A Sheet 2, and the value in column B Sheet 1 equals a value in Column B Sheet 2 then return the value in Column C...
=INDEX(Sheet2!$C$1:$C$1000,MATCH(1,(Sheet1!A1=Sheet2!$A$1:$A$1000)*(Sheet1!B1=Sheet2!$B$1:$B$1000),0))An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.