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.SAA Tables Revised.xlsx

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...selection.html

Thread Closed.