Formula for multiple charts

[batjl9]

Hi

I have attached an excel sheet with 3 charts on it. i have explained what i require in the attachment. Sorry if it is hard to understand.

Basically i do a tipping competition where people pick choose a horse from 5 races, and they get 5 points for the winner, 3 points for 3nd and 1 point for 3rd. in chart c i wish to put results of each of the 5 races. in chart 3 are peoples picks for each race, and i am after if at all possible a way of getting the result in chart b.

So if in race 1 number 4 gets 5 points and one of the people in the competition has chosen number 5, i wouldlike in chart c for 5 to appear as to show they made 5 points from that result.

Thanks
G

[batjl9]

Hi
Just wondering if anyone thinks this type of formula is possible or not?

Any help would be greatly appreciated.

Thanks
G

[Andy Pope]

Try this,

=IFERROR(INDEX($O$1:$Q$1,1,MATCH(B2,$O$2:$Q$2,0)),"")

You will have to modify it going across the 5 columns so the Match part goes down the table in O:Q. Then it will copy down the rows in chartb

[batjl9]

thanks Andy that was exactly what i was looking for. will save me hours.

Gemma