I am using Excel 2003 (currently trying to get them to install 2010) and am trying to do a formula that will lookup a specific amount, then return the amount in another row. Basically the same as vlookup, except what I need it to do is find the amount more than once, and then give me the sum of the referenced amounts. Here is an example:
QMC
Nature Description Workpaper Reference M&E Per Books
67100000 TRAVEL - MEALS A-1 65,464
69100000 TICKETS/ENTERTAINMNT A-1 1,868
67,332
GMC - 01
Nature Description Workpaper Reference M&E Per Books
67100000 TRAVEL - MEALS A-1 302,758
67103000 TRAVEL-MEALS A-1 15,098
67104000 TRAVEL - MEALS A-1 95
67150000 MEALS-DIST AUDIT/CLOSE OUT A-1 14,685
69100000 TICKETS/ENTERTAINMNT A-1 169
7105*0 MEALS AND ENTERTAINMENT A-1 67,761
8405*0 MEALS&ENTERTAINMENT-ADMIN A-1 126,257
526,823
What I am trying to do is get the total of each account. So I'd like to do some type of lookup for account "67100000" and add the amounts from each one. So in this example it would be 65,464+302,758. I can get vlookup to search for one amount and return it, but is there any way to get all of the amounts? I'd like to do this for each of the accounts.
If you need any other information I would be happy to provide it. Thanks for reading!
Bookmarks