Forum Discussion
cstephens88
Jan 19, 2022Copper Contributor
xlookup help
can someone help me with how to write this formula? I need the two yellow cells to auto populate when I choose day of week and type.
4 Replies
- OliverScheurichGold Contributor
=INDEX($C$3:$I$7,MATCH($C14&E$13,$A$3:$A$7&$B$3:$B$7,0),MATCH($B14,$C$2:$I$2,0))
Above INDEX and MATCH formula works in my spreadsheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- cstephens88Copper ContributorThat worked. Thank you so much.
In E14:
=SUMPRODUCT($C$3:$I$7*($A$3:$A$7=$C14)*($B$3:$B$7=E$13)*($C$2:$I$2=$B14))
Fill to the right to F14, then fill down.
- cstephens88Copper Contributorthank you