You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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
VLOOKUP should do it for you (set last argument to FALSE though)
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.
Cheers Stoner
Read my first sentence 🙁
tommy - occassionally, yes
if there are multiple entries then use SUMIF
the help files in excel are handy for learning how to use the formula correctly.
Really is worth taking the time to learn Vlookup
It (& Pivot Chart) really makes spreadsheets "come alive"
[b]Sort[/b] & [b]Concatenate[/b] also dead useful
IMHO
You can use Excel for some pretty far-out things...
http://mashable.com/2014/08/19/microsoft-excel-cool-projects/