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?

Attached Files

Test.xlsx (9.6 KB, 11 views)

Could you please be a little more explicit ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.