Hyperlinks and drop-down lists
Posted by Connie on June 08, 2001 1:21 PM
Here's what I'm trying to accomplish (without using VBA):
I've got a drop-down cell with customer names in it (just made from data validation>list). I'd like for the user to choose the customer from this list, then be able to click on a hyperlink and go to that customer's page (which is a separate worksheet within the same workbook)and read about them. The problem I run into is I've got about 30 customers, and I can only use 7 "IF" statements (i.e.=IF(a1="Smith",HYPERLINK'Smith'!a1,IF(a1="Jones",HYPERLINK'Jones'!a1) etc. I was trying to avoid having 30 different links on the page.