Thread
:
Displaying value according to selected data
View Single Post
09-28-2016, 11:44 PM
jimmy2016
Windows 10
Office 2016
Novice
Join Date: Sep 2016
Location: Hong Kong
Posts: 8
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?
Attached Files
Test.xlsx
(9.6 KB, 11 views)
jimmy2016
View Public Profile
Find all posts by jimmy2016