In Cell E6 I have a number that will change based on what is in cell D6. I want to have a hyperlink in Cell D9 that when it is clicked it goes to a website based on what is in cell E6. So if E6 has "Job" in it I want to go to apples official website but if it contains Weather I want the hyperlink to go to an official weather site. Any ideas?