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?
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.