Show value from table based on selection
Hi all
On an Excel spreadsheet tab I have a table with the following data:
YearSession% Passed% FailedAverageHighest2020July-2055454.882021July-2128725.052022July-2258424.262023July-2382184.062024July-2478224.27
On a separate tab I have the below table. On the data point column I have added a validation drop-down list of the above data points, i.e. % Passed, % Failed, Average and Highest. How can I then display that value in the data value column, taking into consideration the Year and Session? For example the first row below should show 58.
YearSessionData pointData value2022July-22% Passed58
Many thanks!
Hi all On an Excel spreadsheet tab I have a table with the following data: YearSession% Passed% FailedAverageHighest2020July-2055454.882021July-2128725.052022July-2258424.262023July-2382184.062024July-2478224.27 On a separate tab I have the below table. On the data point column I have added a validation drop-down list of the above data points, i.e. % Passed, % Failed, Average and Highest. How can I then display that value in the data value column, taking into consideration the Year and Session? For example the first row below should show 58. YearSessionData pointData value2022July-22% Passed58 Many thanks! Read More
