Need help validating an Excel Formula

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
Matt PinkstonAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
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
 
Matt PinkstonAuthor Commented:
PERFECT
0
All Courses

From novice to tech pro — start learning today.