Displaying value according to selected data

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

    Files

    • Test.xlsx

      (9.85 kB, downloaded 86 times, last: )