Forum Discussion
lilyhandrick
Jul 17, 2023Copper Contributor
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...
OliverScheurich
Jul 17, 2023Gold Contributor
=VLOOKUP(A1&B1,CHOOSE({1,2},Sheet2!$A$1:$A$1000&Sheet2!$B$1:$B$1000,Sheet2!$C$1:$C$1000),2,0)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.