troubleshooting Question

Headcount Report

Avatar of Audra Breedlove
Audra Breedlove asked on
Microsoft ApplicationsMicrosoft Excel
3 Comments1 Solution404 ViewsLast Modified:
Hello,

I need some help.  I can create a formula, but I know that it's going to be a very nested IF/OR, Vlookup and I'm sure this can done easier with Index or Match, maybe.

I have a spreadsheet with a number of employee numbers.  I've used a vlookup formula to bring in the area (Column C on the headcount report) from the value on the Org Exec tab.  Here's the issue.  I have 9 Executives who are from our parent company (KRAFTS).  Their department number is KRF.  I have no way to give them an area, because they all have the same department number.  The executives are the heads of various areas, so I need to identify them in order to add them as a headcount.

The only distinct data point that I have are their employee numbers.  On the Org Exec tab, I've listed the areas, that they need to be associated with (Columns H,I).

I need a formula that says, if the employee number = "24433", then Corporate, else give me the area associated with the deparment number.  That's my thoughts, but I know that you experts, can probably come up with a 2 word formula that would solve this.
Headcount-Formula.xls
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros