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.
Bookmarks