Spreadsheet: 327889d1403710772-lookup-match-and-index-to-return-percentage-to-table-to-draw-a-radar-chart-scoring-tool-2
Sheet: Sheet1

Category | Answer | [NAME] | Percentage
Assurance of Supply | 5 | 5
Assurance of Supply | 2 | 5
Assurance of Supply | 4 | 5 |  |  |  | Row Labels | Product of Percentage
Assurance of Supply | 3 | 5 |  |  |  | Assurance of Supply | 0.6181818181818182
Assurance of Supply | 2 | 5 |  |  |  | Cost | 0.6222222222222222
Assurance of Supply | 2 | 5 |  |  |  | Innovation & Technology | 0.5523809523809524
Assurance of Supply | 5 | 5 |  |  |  | Quality | 0.6347826086956522
Assurance of Supply | 4 | 5 |  |  |  | Service | 0.5826086956521739
Assurance of Supply | 4 | 5 |  |  |  | Grand Total | 0.0785782625244251
Assurance of Supply | 1 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 3 | 5
Assurance of Supply | 3 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 5 | 5
Assurance of Supply | 5 | 5 |  |  |  |  |  | Data will then feed a chart
Assurance of Supply | 1 | 5 |  |  |  | Assurance of Supply
Assurance of Supply | 1 | 5 |  |  |  | Quality | Need to lookup quality in table on LHS where percentage is recorded
Assurance of Supply | 5 | 5 |  |  |  | Service | Need to lookup service in table on LHS where percentage is recorded
Assurance of Supply | 5 | 5 |  |  |  | Cost | Need to lookup cost in table on LHS where percentage is recorded
Assurance of Supply | 2 | 5 |  |  |  | Innovation | Need to lookup innovation in table on LHS where percentage is recorded
Assurance of Supply | 4 | 5
Quality | 5 | 5 |  |  |  |  | Note formula in column D is in this format so rows can be deleted without upsetting % the calculation.
Quality | 4 | 5
Quality | 4 | 5
Quality | 3 | 5
Quality | 1 | 5
Quality | 5 | 5
Quality | 5 | 5
Quality | 1 | 5
Quality | 4 | 5
Quality | 1 | 5
Quality | 1 | 5
Quality | 4 | 5
Quality | 1 | 5
Quality | 3 | 5
Quality | 3 | 5
Quality | 5 | 5
Quality | 3 | 5
Quality | 4 | 5
Quality | 2 | 5
Quality | 4 | 5
Quality | 4 | 5
Quality | 5 | 5
Quality | 1 | 5
Service | 4 | 5
Service | 3 | 5
Service | 2 | 5
Service | 5 | 5
Service | 2 | 5
Service | 4 | 5
Service | 2 | 5
Service | 2 | 5
Service | 1 | 5
Service | 5 | 5
Service | 4 | 5
Service | 2 | 5
Service | 1 | 5
Service | 2 | 5
Service | 2 | 5
Service | 5 | 5
Service | 5 | 5
Service | 1 | 5
Service | 3 | 5
Service | 3 | 5
Service | 4 | 5
Service | 4 | 5
Service | 1 | 5
Cost | 3 | 5
Cost | 3 | 5
Cost | 1 | 5
Cost | 5 | 5
Cost | 3 | 5
Cost | 2 | 5
Cost | 2 | 5
Cost | 4 | 5
Cost | 3 | 5
Cost | 5 | 5
Cost | 4 | 5
Cost | 3 | 5
Cost | 2 | 5
Cost | 3 | 5
Cost | 1 | 5
Cost | 4 | 5
Cost | 4 | 5
Cost | 4 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 2 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 5 | 5
Innovation & Technology | 5 | 5
Innovation & Technology | 2 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 1 | 5