Forum Discussion
Vertical search multiple values
Hey, I have a little problem and I can’t get the formule to work. A B C 1 Bob 10 Januari 2 Bob 20 Februari 3 Bob 30 March 4 Ann ...
=INDEX(sheet1!$C$1:$C$6,MATCH(1,(sheet2!A1=sheet1!$A$1:$A$6)*(sheet2!B1=sheet1!$B$1:$B$6),0))
If the sheetnames are "sheet1" and "sheet2" you can enter this formula in cell C1 of sheet2. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
Thank You for your answer, but it does not work. I've checked it multiple times and i still get #N/B.
Does it work when you open the attached file?