Hyperlink points to address based on input from 2 cells

**CKD777** · 10-15-2011, 11:32 AM

When clicking on hyperlink I want it to open in a separate window and take them to a link that is dependent on what has already been inputed in 2 different cells. EXAMPLE:

If E16 is Male and H16 is over 17 and under 30 then go to this hyperlink Male18-29, but
if E16 is Male and H16 is over 29 and under 40 then go to this hyperlink Male 30-39, but
If E16 is Female and H16 is over 17 and under 30 then go to this hyperlink Female18-29, but
If E16 is Female and H16 is over 29 and under 40 then go to this hyperlink Female 30-39,

I have a lot more "IF's" to add, but if I can get the first 4 above I can wing it from there. THANK YOU!!

**JBeaucaire** · 10-15-2011, 12:05 PM

To create those strings:

=E16 & LOOKUP(H16, {0,18,30,40}, {"1-17","18-29","30-39","40+"})

Now use that as you continue to make your hyperlinks.

**CKD777** · 10-15-2011, 04:01 PM

The formula worked well, thank you.
However still having a problem getting the links pointed in the right direction. Example:
When E16 is Male and H16 is over 17 and under 30 then this comes up in the cell as expected: Male18-29, and then I assign it a hyperlink address to worksheer Male 18-29. Still ok.
However when E16 is Male and H16 is over 29 and under 40 then and Male 30-39, comes up in the cell it still goes to the original place that cell was hyperlinked to Male 18-29, not Male 30-39.
In other words, I can set a hyperlink to the cell but cannot select the text in the cell to give it different hyperlinks. Should I be using a drop down menu? Is there a way to turn items in drop downs into individual links?