Excel Excel: Match, Index and subtract across 2 columns and 2 tabs


Joined
Aug 27, 2014
Messages
2
Reaction score
0
Hello!
Here's what I've been tasked with:
I'm setting up a spreadsheet to track invoices. I have 2 tabs. The first tab records the Purchase Order Number, Supplier, terms, the amount of the PO and a few other items. The second tab tracks invoices. What I hope to accomplish is this: When a user enters the invoice info - they will also enter what PO number the invoice should be applied to. I want to set up a column 'Balance of Invoice' on the first tab that will automatically look at the list of invoices and subtract if the POs match. I'm thinking Index, match will work but I need assistance. Any feedback is greatly appreciated. thank you
 
Joined
Sep 3, 2008
Messages
163
Reaction score
5
LoriD2014,
I use a similar workbook to total entries from several sources. I use sumif. If you post the names of the spreadsheets and the ranges for the PO and invoice totals I can mock up your formula.
Stoneboysteve
 
Ad

Advertisements

Joined
Aug 27, 2014
Messages
2
Reaction score
0
StoneboySteve,
Thank you for your response! I will post the spreadsheet on Tuesday (I'm away for the weekend). Thank you in advance for your assistance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top