Formula for multiple charts

batjl9 · #1 07-18-2009, 01:02 PM

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 · #2 07-19-2009, 02:10 AM

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

Any help would be greatly appreciated.

Thanks
G

Andy Pope · #3 07-19-2009, 07:41 AM

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 · #4 07-19-2009, 11:35 AM

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

Gemma

Welcome to the Excel Forum

Forum Statistics