Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup based on list selection in cell
Hello all,
In sheet Student Analysis, I have a column (G8:G37) which looks up whether the cells I1:I33 (in Summary sheet) is lower than C4:C33 (in Master Sheet) and shows the value in A4:A33 (in Summary Sheet) if it is. Essentially it looks up whether a students % mark is lower than their target, and shows their name if it is. If it is higher then it shows nothing (""). What I want to do: - Be able to select a topic (column in summary sheet) - Show students with a mark lower than their target for that topic only - I've created a list box in H2 which has the headings from the 'Summary' Sheet (I3:O3) - I now need to filter (G8:G37) to only show the column based on the topic selected in H2. Example, if Topic 3 is selected in the Student Analysis sheet, G8:G37 should show K4:K33 (from Summary sheet), if Topic 5 is selected G8:G37 should show M4:M33 (from Summary Sheet). Link to spreadsheet HERE Cheers, Luke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best method to populate cell based upon drop down list selection | Excel Discussion (Misc queries) | |||
Show cell value based on list selection | Excel Programming | |||
set cell values based on selection from list | Excel Programming | |||
Setting Cell Value Based on List selection | Excel Programming | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |