I have a summary sheet that has about 4500 rows on it .... basically it has employee number, cost centre, subjective columns followed by amounts by month. This is all OK. Now, however, I have to give these numbers text equivalents. That is I have to put a name matching to an employee number, and a location matching on BOTH the employee number AND cost centre.
So, I need two new columns. I have created a look up sheet within the same workbook that has names, locations and cost centres on it. It becomes a bit difficult because one employee number can have multiple cost centres and, hence, corresponding locations. BUT cost centres can have different locations.
Cost centres EB-ED correspond to particular locations but from EE onward they relate to a budget centre rather than a location and hence have multiple locations.
So, HELP!!! I'm not sure what formula to use - if any - have tried the IF function but that seems to require a value and doesnt want to return text.
Clear as mud .... thought so! Any help though would be outstanding.
So, I need two new columns. I have created a look up sheet within the same workbook that has names, locations and cost centres on it. It becomes a bit difficult because one employee number can have multiple cost centres and, hence, corresponding locations. BUT cost centres can have different locations.
Cost centres EB-ED correspond to particular locations but from EE onward they relate to a budget centre rather than a location and hence have multiple locations.
So, HELP!!! I'm not sure what formula to use - if any - have tried the IF function but that seems to require a value and doesnt want to return text.
Clear as mud .... thought so! Any help though would be outstanding.