ChristopherM
IS-IT--Management
I am trying to construct a spreadsheet to convert sales from a list of old departments to new departments. Each new department represents between two and twenty old departments. I started with sheet 1 with column A containing the old department (olddep) numbers and column B the olddep sales. Sheet2 Column A contains the newdep numbers and column B a formula such as =VLOOKUP(...) + VLOOKUP(...) + VLOOKUP(...) etc This has been very hard to debug when the two sheets don't come to the same total. I have been told I should have a third sheet where column A is the newdep and columns B,C,D etc the olddeps that make it up, then use an array VLOOKUP in the newdep sales sheet which will use the info in the conversion table to total the relevant olddep sales.
But I have no idea if this is really possible and if so how it should be done. Anybody got any ideas? Thanks in advance for your help.
But I have no idea if this is really possible and if so how it should be done. Anybody got any ideas? Thanks in advance for your help.