Forum Discussion
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.
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.
- thank you
