I have 2 sets of data. What's the best way to reconcile one against the other?
I've got 3 columns in each data set: dept, acct, and amount. I need to get the total amount per dept and account combination in data set #1 reconciled against the same thing from data set #2.
I don't know if a vlookup can work or pivot tables or some function I'm not already familiar with.... Help! Anyone have any suggestions on how to attack this?
Bookmarks