View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default I need help writing a complex equation.


","hor izonair.com")

If you want the result to be a link:

=HYPERLINK(B1&"."&C1&"@"&IF(A1="01XXXX","alaskaair .com","horizonair.com"))

HTH,
Paul

--

"drummer07" wrote in message
...
I have three columns that I want to draw data from combine it into a single
line of data in another columns. So here's the scenario.

Column 1 has an employee # there's two designations 01XXXX and 02XXXX.
This is important. More on the importance of that later.

Column 2 has First name

Column 3 has Last name pretty simple.

So basically what I need to happen is, what I believe to be a simple
combination / complex if statement.

The Final column would look like this.


That's why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02
mean
horizonair.com

Help!

-jeremy-