Forum Discussion
Excel Equation Not Working?!
I need an equation (that works) to show the value of a cell in a different sheet. for example: Sheet1 has Column A as a person's name. Column B, C & D have numbers 1-60 listed. (So each person could...
This is great! How could I add an additional match?
I need to select 1 of 4 age groups before listing the name.
I need to select 1 of 4 age groups before listing the name.
=INDEX($A$1:$A$10,MATCH(1,MMULT(--($B$1:$D$10=H1)*($E$1:$E$10=G1),{1;1;1}),0))
Maybe as shown in the attached file.
- I assumed that would work as well, but I am getting an NA....??
What Excel version do you work with? If you don't work with Office365 or 2021 you have to enter the formula as arrayformula with ctrl+shift+enter. Maybe you want to attach a file that shows your data, formula and error message.