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

Excel Discussion in 'Microsoft Office' started by LoriD2014, Aug 27, 2014.

  1. LoriD2014

    LoriD2014

    Joined:
    Aug 27, 2014
    Likes Received:
    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
     
    LoriD2014, Aug 27, 2014
    #1
    1. Advertisements

  2. LoriD2014

    Stoneboysteve

    Joined:
    Sep 3, 2008
    Likes Received:
    5
    Location:
    USA
    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
     
    Stoneboysteve, Aug 31, 2014
    #2
    1. Advertisements

  3. LoriD2014

    LoriD2014

    Joined:
    Aug 27, 2014
    Likes Received:
    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!
     
    LoriD2014, Aug 31, 2014
    #3
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.