title: Excel - find a value and copy into different sheets
body: <p>I need some help with a formula i am trying to make for a mark book. 
  I have a work book, with a sheet labelled "Master" that contains students unique reference numbers in col A2, their names B2/C2 and then the four subjects they study in col D2,E2,F2 and G2.  I also then have separate sheets for each individual subject.</p>
  
  <p>I would like to look up the subjects on the master sheet (in the four columns) and if "Maths" is a subject a student takes in one of those columns, i would like the corresponding student name and reference from that row to be copied and pasted into the sheet "Maths" so further information can be entered regarding that subject/student and class.</p>
  
  <p>I have tried working with a IF and MATCH formula but it seems to get quite complex, as I have over 400 students who each have four subjects, and the subjects can appear in anyone of the four subject columns.</p>
  
  <p>Any suggestions?</p>
  
  <p>TIA!</p>