VLOOKUP Formula help!

N

Nicky D

I have students who have chosen subjects from a list, now I need a list of
students doing the subjects eg:

Name A B C D
Yousuf Abbood Econ App ICT Ma Stat Eng Com
Mohammad Abboud
Eniola Adesanya Ma Stats Soc Econ ICT Part
Zoheb Ahmed Btec Nat Bus Btec Nat Bus RE ICT Part


I need This.....
Name App ICT(part) Economics Eng Comb Ma Stats Maths Fur Etc...
Yousuf Abbood Yes Yes Yes Yes

Any ideas?
 
Top