Excel

I have a spreadsheet, list of names (rows) to the right and subjects in columns along the top row.

The spreadsheet is for subjects students wish to take and there are 15 or so options but the girls can only choose 3 by putting a number of 1 to 3 under the subjects on offer. I then need to do a mail merge but would like the letter to say 'Option 1 - Maths' Option 2 - French' etc.

For the mail merge I need 3 new columns to the right of the last option column so that I can transfer each students 3 options in order. I think I need an 'if' statement saying if cell has 'option 1' then copy the details of that cell to the new cell, and if the cell does not say 'option 1' then continue to the next cell until 'option 1' is found.

I can only work out how to change the cell colour etc by using the 'if' statement but can’t find out how to copy the data across. Can you help?

I can send you a copy of the spreadsheet if it helps - Sharon
Please reply to my work email tingly-s@nonsuch.sutton.sch.uk