I'm trying to find out if there is a formula out there that will allow a particular named range to show depending on a particular cell value.

For example, in cell E2 (in sheet 1 named "Work Order"), if you select 2928 from the list available, then in cell I2 you can select values from a range called Task_2928 (which has been created in sheet 2 named "Ranges"), or if you select 3417 from the list in E2, you can select from a range called Task_3417 etc. There are 15 different numbers you can select in cell E2.

I'm not sure if this can be done with a formula, or if some kind of macro would need to be created??

If anyone can help, that would be marvellous!

Thanks
Emma