 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008I need help writing a complex equation.
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. jeremy.ries@horizonair.com That’s why 01xxxx and 02xxxx are so important 01 means alaskaair.com 02 mean horizonair.com Help! -jeremy- drummer07@hotmail.com Jeremy@jeremyries.net =B1&"."&C1&"@"&IF(A1="01XXXX","alaskaair.com","horizonair.com") If you want the result to be a link: =HYPERLINK(B1&"."&C1&"@"&IF(A1="01XXXX","alaskaair.com","horizonair.com")) HTH, Paul >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. [quoted text clipped - 20 lines] > drummer07@hotmail.com > Jeremy@jeremyries.net In column D: =HYPERLINK("mailto:" & B1&"."&C1&"@"&IF(LEFT(A1,2)="01","alaskaair.com","horizonair.com"))  SignatureGary''s Student - gsnu200775 > 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. [quoted text clipped - 19 lines] > drummer07@hotmail.com > Jeremy@jeremyries.net with the data laid out as described in A1, b1 & c1 try this in d1 and drag down =B1&"."&C1&"@"&IF(LEFT(A1,2)="01","alaskaair","horizonair") Mike > 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. [quoted text clipped - 19 lines] > drummer07@hotmail.com > Jeremy@jeremyries.net something like this should do with data in cells a2, b2 and c2... =B2& "." & C2 & IF(LEFT(A2, 2) = "01", "@alaskaair.com", "@horizonair.com") SignatureHTH... Jim Thomlinson > 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. [quoted text clipped - 19 lines] > drummer07@hotmail.com > Jeremy@jeremyries.net hi play with this..... =IF(LEFT(A2,2)="01",B2&C2&"@"&"alaskaair.com",B2&C2&"@"&"horizon.com") regards FSt1 > 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. [quoted text clipped - 19 lines] > drummer07@hotmail.com > Jeremy@jeremyries.net YOU GUYS ROCK! THANKS! EVERYONE OF THOSE ANSWERS WORKED! WHAT A GREAT COMMUNITY! > hi > play with this..... [quoted text clipped - 26 lines] > > drummer07@hotmail.com > > Jeremy@jeremyries.net cool. and you know what they say... more than one way to skin a mamoth. regards FSt 1 > YOU GUYS ROCK! THANKS! EVERYONE OF THOSE ANSWERS WORKED! WHAT A GREAT > COMMUNITY! [quoted text clipped - 29 lines] > > > drummer07@hotmail.com > > > Jeremy@jeremyries.net |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.