Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Microsoft Certification (http://www.velocityreviews.com/forums/f24-microsoft-certification.html)
-   -   Function search (http://www.velocityreviews.com/forums/t673913-function-search.html)

red 03-02-2009 11:03 AM

Function search
 
I am trying to search fro two pieces of infomation from one cell.
For one piece i have used =IF(LEFT(J11,2)="Ph",L11,""). What i want to be
able to do is search for either "Ph" or "In" from the same cell. Is this
possible? I think i have seen this done by setting a special function and
VB!!

Lawrence Garvin \(MVP\) 03-02-2009 04:03 PM

Re: Function search
 
"red" <red@discussions.microsoft.com> wrote in message
news:C0574E93-0CDE-44C7-A389-908AA4E62455@microsoft.com...
>I am trying to search fro two pieces of infomation from one cell.
> For one piece i have used =IF(LEFT(J11,2)="Ph",L11,""). What i want to be
> able to do is search for either "Ph" or "In" from the same cell. Is this
> possible?


It's possible. Asking in the right FORUM will get you the answer a whole lot
faster.


=IF(LEFT(J11,2)="Ph", L11, IF(LEFT(J11,2)="In",L11,"") )

Essentially you use the ELSE block of the first IF statement to execute the
IF test for your second (or subsequent) strings of interest. So, if J11 is
not "Ph" then test to see if it its "In", if so, perform the same assignment
(L11), if not, leave it blank.


--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Principal/CTO, Onsite Technology Solutions, Houston, Texas
Microsoft MVP - Software Distribution (2005-2009)

MS WSUS Website: http://www.microsoft.com/wsus
My Websites: http://www.onsitechsolutions.com;
http://wsusinfo.onsitechsolutions.com
My MVP Profile: http://mvp.support.microsoft.com/pro...awrence.Garvin



All times are GMT. The time now is 05:40 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.