Hi, I'm hoping someone could help. I'll explain what I'm trying to achieve and then what I've tried below that.
I have Sheet1 with 2 account columns and actuals data in column 3. I want to bring in the forecast and budget data from Sheet2, however there may be additional combinations in sheet 2 that don't exist on sheet1.
Sheet1
Account SubAccount Actual Fcst Budget
100000 9000 500.00
200000 5000 250.00
300000 7000 1000.00
Sheet 2 will have Fcst and Budget data against the same and additional account combinations. Account 200000 from Sheet 1 doesn' t exist and the last 2 lines are new combinations that don't exist in Sheet 1.
Sheet2
Account SubAccount Fcst Budget
100000 9000 500.00 1000
300000 7000 1000.00 1000
400000 9000 700.00 1000
300000 9000 800.00 1000
The result would be a combination of both the sheets pulling with all the combinations and data.
Result
Account SubAccount Actual Fcst Budget
100000 9000 500.00 500.00 1000
200000 5000 250.00
300000 7000 1000.00 1000.00 1000
400000 9000 700.00 1000
300000 9000 800.00 1000
I've been trying to solve this problem with vlookup and index formulas without much joy. So I can look up the account combinations with a sumif and compare, but can't figure out how to add the new ones. I can identify new combinations in both sheets with a vlookup, but struggle to combine into one list and bring the values into one sheet. As I need to do this regularly, this would be best suited to a macro. Any help?
Bookmarks