drop down menus and corresponding hyperlinks

[Kimmie40]

Hello World,

In my spreadsheet I have a series of cascading drop down menus. I
would like it if I could drop down cell A9 to select "1120e" and when
you do that cell A10 provides a link to another tab in the spreadsheet
or to another document. That link depends on what you selected in A9.

Thanks,
Kim

 

[Pete_UK]

This could be done, but how would "1120e" indicate where to jump to?
Do you have a list of items that could be selected in A9 (you must
have for the drop-down to work) and a related list showing where they
would link to?

Pete