Solved

Sequence on Excel Formula

Posted on 2014-04-28
3
155 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

757 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now