Forum Discussion
RVLIES905
Dec 30, 2021Copper Contributor
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...
OliverScheurich
Dec 30, 2021Gold Contributor
=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.
- RVLIES905Jan 10, 2022Copper ContributorThis is great! How could I add an additional match?
I need to select 1 of 4 age groups before listing the name.- OliverScheurichJan 10, 2022Gold Contributor
=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.
- RVLIES905Jan 11, 2022Copper ContributorI assumed that would work as well, but I am getting an NA....??