Forum Discussion
smc1906
Jun 21, 2024Copper Contributor
Show value from table based on selection
Hi all On an Excel spreadsheet tab I have a table with the following data: Year Session % Passed % Failed Average Highest 2020 July-20 55 45 4.8 8 2021 July-21 28 72 5....
dscheikey
Jun 21, 2024Bronze Contributor
You can use XLOKUP() within XLOOKUP().
=XLOOKUP(C2,Table1[#Headers],XLOOKUP(A2,Table1[Year],Table1))
See also my enclosed sample document.