Solved

Sequence on Excel Formula

Posted on 2014-04-28
3
160 Views
Last Modified: 2014-05-07
In the following formula, what is the sequence of setting the values?  in other words if M2 has Defense & Navy keywords which would get the setting

=IF(OR(LEFT(D2,3)="CS-",LEFT(D2,4)="CS -"),"Consulting & Intelligence",LOOKUP(9.9999E+307,SEARCH({"Civilian","CONSULT","Defense","Navy","Healthcare","Sled"},M2),{"Civilian","USPS Intel","Defense/Fedsec","Navy/USMC","Healthcare","S&L"}))
0
Comment
Question by:Matt Pinkston
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 40027131
Whichever one is last in the search array.
0
 
LVL 14

Assisted Solution

by:Faustulus
Faustulus earned 250 total points
ID: 40027133
Is this the formula you are after?
=IF(OR(LEFT(D2,3)="CS-",LEFT(D2,4)="CS -"),"Consulting & Intelligence",LOOKUP(M2,{"Civilian","CONSULT","Defense","Healthcare","Navy","Sled"},{"Civilian","USPS Intel","Defense/Fedsec","Healthcare","Navy/USMC","S&L"}))

Open in new window

It would be if M2 holds one of the text items in the Lookup_Vector.
You may wish to read up on the LOOKUP function in Excel's own help.
0
 

Author Closing Comment

by:Matt Pinkston
ID: 40048167
Thanks Guys
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question