BanderSnatch
New Member
- Joined
- May 16, 2016
- Messages
- 4
Hi
I need to summarise each of our suppliers invoices on a separate forecast/actuals tab. Can I use VLOOKUP for this?
Example month ....
<colgroup><col><col><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>
</tbody>
I need to summarise each of our suppliers invoices on a separate forecast/actuals tab. Can I use VLOOKUP for this?
Example month ....
Date | Type | Description | Total | NET | VAT | Expected Income | Expected Income NET | Expected Income VAT | Running Balance |
AXA PPP | £91.61 | £76.34 | £15.27 | £ - | £ - | £76.34 | |||
Royal London | £125.06 | £104.22 | £20.84 | £ - | £ - | -£27.88 | |||
Sun Organisation | £32,396.30 | £ 26,996.92 | £ 5,399.38 | £ - | £ - | -£27,024.79 | |||
RBOS PLC Mentor | £169.19 | £140.99 | £28.20 | £ - | £- | -£27,165.78 | |||
Vodafone Ltd | £ 490.19 | £ 408.49 | £ 81.70 | £- | £ - | -£27,574.28 |
<colgroup><col><col><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>
</tbody>