Displaying value according to selected data

alibaba · Sep 29th 2016

In E2, I want a formula that displays the amount based on the table and what StudA has chosen.
vlookup can help.
But how to decide which day studA has chosen?
That is,
StudA chose Mon and was given $200, StudB chose Wed and was given $300.
A formula is required to display such values in E2:E4
Thanks for help.

skywriter · Sep 29th 2016

Re: Displaying value according to selected data

Put this formula in E2 and copy down. :cool:

Code

=SUMPRODUCT(($B2:$D2=1)*($B$1:$D$1=$G$2:$G$4)*($H$2:$H$4))

Displaying value according to selected data

Participate now!

Share