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...
=INDEX($A$1:$A$10,MATCH(1,MMULT(--($B$1:$D$10=F1),{1;1;1}),0))
An alternative would be above formula. If you don't work with Office365 or 2021 enter formula as arrayformula with ctrl+shift+enter.
- This is great! How could I add an additional match?
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....??
