How to lookup a value in an unsorted list

The table below is an extract showing the responses to Class preferences. I want to run a formula that gives me a column with choice 1 and another with choice 2 without having to sort the data. I’ve tried LOOKUP but it won’t work on unsorted row data.

 

NAME ClassA ClassB ClassC ClassD 1 2
Fergal 1 2 3 4 ClassA ClassB
Brian 3 2 1 4 #N/A ClassC
Sophia 3 2 1 4 #N/A ClassC
Susan 4 2 1 3 #N/A ClassC
Micelle 4 2 1 3 #N/A ClassC
Harley 4 2 1 3 #N/A ClassC
Tim 4 2 1 3 #N/A ClassC
Mairead 1 3 2 4 ClassA ClassC
Michael 4 3 1 2 #N/A ClassD
Fintan 4 3 1 2 #N/A ClassD
John 4 3 1 2 #N/A ClassD
Sharon 4 3 1 2 #N/A ClassD
Grace 4 3 1 2 #N/A ClassD
Alan 2 4 1 3 #N/A ClassC

By: Ivan McCutcheon

Leave a Reply

Your email address will not be published. Required fields are marked *