In our computer system, we have different codes for everyday tasks. Problem is the codes are different for each division we have.
East Division codes for BUY are 10, 84, and 78
West Division codes for BUY are 10 and 84
South Division codes for BUY are 10
What formula in Excel should I use to list all the task codes that each division has? Ideally I should be able to look up task code name (BUY) and three windows cou;ld show the code numbers for each division.
By: John Barnett