formula help lookup

[scarp]

Hi all, i need some help with creating a dashboard of results and i don't know how to do it.

Basically, i have a input of data sheet that looks like this, only more data:
[TABLE="width: 466"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 3"]The YTD Savings is based on a sumif statement adding each month past.

Data sheet
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]YTD Savings[/TD]
[/TR]
[TR]
[TD]Supplier
[/TD]
[TD]Plan[/TD]
[TD]$$[/TD]
[/TR]
[TR]
[TD]supplier 1[/TD]
[TD]Actual [/TD]
[TD]$$[/TD]
[/TR]
[TR]
[TD]supplier 1[/TD]
[TD]Increases[/TD]
[TD]$$
[/TD]
[/TR]
[TR]
[TD]supplier 2[/TD]
[TD]Plan[/TD]
[TD]$$[/TD]
[/TR]
[TR]
[TD]supplier 2[/TD]
[TD]Actual [/TD]
[TD]$$[/TD]
[/TR]
[TR]
[TD]supplier 2
[/TD]
[TD]Increases[/TD]
[TD]$$[/TD]
[/TR]
[TR]
[TD]supplier 3[/TD]
[TD]Plan
[/TD]
[TD]$$[/TD]
[/TR]
[TR]
[TD]supplier 3[/TD]
[TD]Actual
[/TD]
[TD]$$[/TD]
[/TR]
[TR]
[TD]supplier 3[/TD]
[TD]Increases[/TD]
[TD]$$
[/TD]
[/TR]
</tbody>[/TABLE]


I want to create a dashboard that contains this data in a more readable format for quick review and then add a chart for visual reference.
Similar to below, but i don't know how to do lookups from multiple datapoints.

Am i over thinking this task. Can anybody help?

 

[oldbrewer]

below is not there so it is hard to see what you want

we could rank by actuals or increases ??