<div>
Try this in C2<br />
<br />

<pre><code id="code-20-40893936-1">=&quot;www.domain.com/&quot;&amp;B2</code></pre>
and copy down.
</div>


Try this in C2



="www.domain.com/"&B2

and copy down.

<div>
hi sktneer, sorry but that did not work for me. it only shows the text I have entered.
</div>


hi sktneer, sorry but that did not work for me. it only shows the text I have entered.

<div>
You need to apply that formula in C2..<br />
<br />
SO in C2 it will say..<br />
<br />
=&quot;www.domain.com/&quot;&amp;B2<br />
<br />
Now if you need to build hyperlink to it then it will say...<br />
<br />
=HYPERLINK(&quot;www.domain.com/&quot;&amp;B2,B2)<br />
<br />
Saurabh...
</div>


You need to apply that formula in C2..

SO in C2 it will say..

="www.domain.com/"&B2

Now if you need to build hyperlink to it then it will say...

=HYPERLINK("www.domain.com/"&B2,B2)

Saurabh...

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I would like a formula to provide several outcomes depending upon the entry in another column.<br />
<br />
so...... column B will have types of business eg clinic, chiropractor, dentist etc etc<br />
<br />
I would like column C to auto enter a web address for landing pages eg www.domain.com/clinic, www.domain.com/chiropractor, www.domain.com/dentist&nbsp;etc etc<br />
<br />
Is this possible?<br />
<br />
TIA<br />
Gareth
</div>
</div>


Hi, 

I would like a formula to provide several outcomes depending upon the entry in another column.

so...... column B will have types of business eg clinic, chiropractor, dentist etc etc

I would like column C to auto enter a web address for landing pages eg www.domain.com/clinic, www.domain.com/chiropractor, www.domain.com/dentist etc etc

Is this possible?

TIA
Gareth

Excel IF/THEN for several outcome

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.