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 ....

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>

 

[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