Viewing 8 posts - 1 through 8 (of 8 total)
  • Excel question
  • I’m an Excel numpty, so don’t know if this is possible

    I have a spreadsheet and one one sheet are all my invoices and payments with dates against them in a separate column. I also have a balance sheet on a different sheet with a rolling date down the left hand column, then various columns for costs/payments/vat etc.

    What I want to achieve is, when the date in a column on the invoicing sheet matches the corresponding date on the balance sheet, a particular cell on the balance sheet is populated by the payment amount on the invoicing sheet. Bear in mind that the invoice sheet doesn’t have a rolling date column – just the date that I manually input, so the cells won’t be in a constant place.

    Cheers

    Stoner
    Free Member

    VLOOKUP should do it for you (set last argument to FALSE though)

    tommyhine
    Full Member

    will there be many invoices with the same date trying to fit into one date on the balance sheet?

    If so you’ll need to use the sumif formula. Otherwise the VLOOKUP formula will be fine.

    Fresh Goods Friday 696: The Middling Edition

    Fresh Goods Friday 696: The Middlin...
    Latest Singletrack Videos

    Cheers Stoner

    Read my first sentence 🙁

    tommy – occassionally, yes

    Stoner
    Free Member

    if there are multiple entries then use SUMIF

    the help files in excel are handy for learning how to use the formula correctly.

    samunkim
    Free Member

    Really is worth taking the time to learn Vlookup

    It (& Pivot Chart) really makes spreadsheets “come alive”

    Sort & Concatenate also dead useful

    IMHO

    piedidiformaggio
    Free Member

    You can use Excel for some pretty far-out things…

    http://mashable.com/2014/08/19/microsoft-excel-cool-projects/

Viewing 8 posts - 1 through 8 (of 8 total)

The topic ‘Excel question’ is closed to new replies.