Vlookup needed?

[BanderSnatch]

Hi

I need to summarise each of our suppliers invoices on a separate forecast/actuals tab. Can I use VLOOKUP for this?

Example month ....

[TABLE="width: 909"]
<colgroup><col><col><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Type[/TD]
[TD]Description[/TD]
[TD] Total [/TD]
[TD] NET [/TD]
[TD] VAT [/TD]
[TD] Expected Income [/TD]
[TD] Expected Income NET [/TD]
[TD] Expected Income VAT [/TD]
[TD] Running Balance [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]AXA PPP[/TD]
[TD] £91.61[/TD]
[TD] £76.34[/TD]
[TD] £15.27[/TD]
[TD] [/TD]
[TD] £ - [/TD]
[TD] £ - [/TD]
[TD] £76.34[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Royal London[/TD]
[TD] £125.06[/TD]
[TD] £104.22[/TD]
[TD] £20.84[/TD]
[TD] [/TD]
[TD] £ - [/TD]
[TD] £ - [/TD]
[TD]-£27.88[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Sun Organisation[/TD]
[TD] £32,396.30[/TD]
[TD] £ 26,996.92[/TD]
[TD] £ 5,399.38[/TD]
[TD] [/TD]
[TD] £ - [/TD]
[TD] £ - [/TD]
[TD]-£27,024.79[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]RBOS PLC Mentor[/TD]
[TD] £169.19[/TD]
[TD] £140.99[/TD]
[TD] £28.20[/TD]
[TD] [/TD]
[TD] £ - [/TD]
[TD] £- [/TD]
[TD]-£27,165.78[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Vodafone Ltd[/TD]
[TD] £ 490.19[/TD]
[TD] £ 408.49[/TD]
[TD] £ 81.70[/TD]
[TD] [/TD]
[TD] £- [/TD]
[TD] £ - [/TD]
[TD]-£27,574.28[/TD]
[/TR]
</tbody>[/TABLE]

 

[CisaBP]

What part of the above are you trying to summarise? You may need to provide a bit more information. Do you just want totals? Do suppliers show more than once on the spreadsheet? So are AXA PPP likely to be on the list multiple times and you just want the totals?

Chances are the best it's a pivot table you need or SUMIF formula.

 

[DILIPandey]

Hi BanderSnatch,

I believe the sample data which you have given is your expected output.
Can you share a sample of source (raw) data as well? Thanks.


Regards,
DILIPandey