Lookup, match and index to return percentage to table to draw a radar chart

[smudgepost]

I'm struggling with match, index and lookup functions. I have a formula in column D that calculates the percentage of answers against the total score for that category. The way it calculates enables me to delete rows if they are not needed and still provide a total count and a percentage score.

Now the percentage is returned from a dynamic data set, I want to plot the percentages on a spider/radar chart. Instead of manually creating the chart or using a pivot, I wanted to lookup the percentages (column D) against the category (Column A) in question and plot so the chart updates as the user changes the answers.

This is part of a survey where each category has questions that have 5 possible answers. All suggestions welcome.

[judgeh59]

So this does what you asked....I believe.....but it does assume a few things.

1) your labels will match what is Column A
2) it will only return the first occurance of the match for what is in column A

HTH

[judgeh59]

Probably would help if I attach a file.....

[judgeh59]

So was this helpful?