Referencing cell contents in a web hyperlink

[muyandrea]

Hello!

I'm working on a project and have already learned a lot about Excel's options.. however there's one thing I can't figure out.

I'm hyperlinking to a large car rental website that offers services for several cities. However, I want it to automatically link to the city that appears in another cell on the same worksheet.

For example, I have a hyperlink in cell D2; if I write "Los Angeles" in the other cell (G1), I want the hyperlink to automatically link to the Los Angeles car rental website. Or, if I change G1's contents to "New York", I want the hyperlink to automatically link to the New York website. Is this possible?

How can I get the hyperlink to automatically search the contents of another cell?

Thanks!

 

[daverunt]

Where sheet3 A4 contains the word 'about'
You can use the concatenator '&' mid link too

=HYPERLINK("[URL]http://www.simplewebsite.org/[/URL]"& Sheet3!A4)
 
[/Cose]

 

[muyandrea]

thanks for your help this works