Lookup based on list selection in cell

L

lukestkd

Hello all,

In sheet Student Analysis, I have a column (G8:G37) which looks u
whether the cells I1:I33 (in Summary sheet) is lower than C4:C33 (i
Master Sheet) and shows the value in A4:A33 (in Summary Sheet) if i
is.

Essentially it looks up whether a students % mark is lower than thei
target, and shows their name if it is. If it is higher then it show
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 th
'Summary' Sheet (I3:O3)
- I now need to filter (G8:G37) to only show the column based on th
topic selected in H2.

Example, if Topic 3 is selected in the Student Analysis sheet, G8:G3
should show K4:K33 (from Summary sheet), if Topic 5 is selected G8:G3
should show M4:M33 (from Summary Sheet).

'Link to spreadsheet HERE' (http://tinyurl.com/d2ggjtz)

Cheers,

Luk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top