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