Inserting values based upon a drop down box selection

Hi all, just after some help thanks. I've got a spreadsheet with a drop down box which has 5 variables. Depending upon the selection made (cell C2), I want it to insert corresponding values into cells F6:F12 from columns K6:012. I've tried using some IF functions but it gets too messy and doesnt work properly. Maybe I should be using a named range or similar but thats a bit out of my skill level. See attached spreadsheet for more details. Basically if C2 is set to Conservative then I would like to insert K6:K12 into F6:F12. or if C2 is set to Aggressive then I would like to insert the values from O6:O12 into F6:F12. Hope that makes sense and thanks in advance.

HLOOKUP is your friend; see attachment.

You will see row argument ROW()-3; basically, this defines which row from K6:012 is "the chosen one"; so, for cell F6 it's 3 (first row is caption, "Conservative", second row is empty, and third row is 10%, which you want to pick up), for cell F7 it's 4, and so on; but rather than changing it in each row, I connected it to row number, so you can simply copy the formula down. This will work as long as source and destination are in the same order like in this example; if you change it, you will need to adjust that.

That is awesome and works perfectly. Thank you very much and greatly appreciated.