Solved

Need help validating an Excel Formula

Posted on 2014-04-18
2
126 Views
Last Modified: 2014-05-07
Is the formula coded wright?

=IF(LOOKUP(9.9999E+307,SEARCH({"Civilian","CONSULT","Defense","Navy","Healthcare","Sled"},J1),{"Civilian","USPS Intel","Defense/Fedsec","Navy/USMC","Healthcare","S&L"}))


Basically I am looking at column J for some keywords then setting this column to a value based on the findings
0
Comment
Question by:Matt Pinkston
2 Comments
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
ID: 40008451
Hello,

it works if you remove the IF() wrapped around it

=LOOKUP(9.9999E+307,SEARCH({"Civilian","CONSULT","Defense","Navy","Healthcare","Sled"},J1),{"Civilian","USPS Intel","Defense/Fedsec","Navy/USMC","Healthcare","S&L"})

or, to trap errors, wrap it in IFError()

=iferror(LOOKUP(9.9999E+307,SEARCH({"Civilian","CONSULT","Defense","Navy","Healthcare","Sled"},J1),{"Civilian","USPS Intel","Defense/Fedsec","Navy/USMC","Healthcare","S&L"}),"")

cheers, teylyn
0
 

Author Closing Comment

by:Matt Pinkston
ID: 40048161
PERFECT
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
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 use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

747 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

13 Experts available now in Live!

Get 1:1 Help Now