Forum Discussion
Solved
sumif?
Hello. I have a situation. I would like to return the value, lets say in Q4 Scenario 1 and 2 in the correct cell. I am not having any luck as it is returning some numbers that do not even make ...
It works in my Excel 2013 sheet when i enter the formula with ctrl+shift+enter. Which version of Excel do you work with? You have to enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. Ctrl+shift+enter puts the curly brackets {} around the formula and calculates the arrayformula.
=IFERROR(INDEX($B$9:$K$11,MATCH($A3,$A$9:$A$11,0),MATCH(1,(B$2=$B$8:$K$8)*(B$1=$B$7:$K$7),0)),"no match")If you remove the merged cells you can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
OliverScheurich Thanks for this. ON the previous example, it seems to work. But when I applied it, it didnt work for me somehow. I have re-attached an example with the formula suggested. Thanks for sharing your knowledge.