I have a spreadsheet to track expenses for various business units. A unit may have up to two different budgets, consisting of the following:
A GL code
A description for that code.
Ex:
Tab A: Budget 1
A B
1 41100 Electricity
2 43364 Building Maintenance
3 42030 Uniforms
Tab B: Budget 2
A B
1 41100 Electricity
2 43364 Building Maintenance
3 45000 Travel
I have a tab for each potential budget. Each Budget may have some of the same GL Codes, and some unique. Users may post new Codes and descriptions to either budget.
What I need is to generate a list of codes and descriptions, in Ascending order, from both tabs, so I can use vlookup to match a code to a description on another tab.
Considerations:
Different units have different budgets, so I want them to be able to load budgets in the relevant tabs, and have the list populate accordingly.
At any time, they may add or delete GL codes from the budget, and I want the vlookup list to update accordingly.
I tried working with Rank function, but it didn't seem to work with my setup. I suspect that because of the duplicates from one budget to the next, it went wonky.
Bookmarks