I am trying to create a complex formula and not sure how to do it. Hoping
that someone here can help. I have 2 spreadsheets, one's called "Angler of
the year" and the other is called "CLinton Lake". On the Clinton lake sheet,
I have the names of all members in the club. Each member could end up in
either 1st,2nd,3rd,4th,5th,6th,7th,8th place and so on. For each place there
is a point value. 1st is gonna be worth 300 points, 2nd is gonna be 250
points, 3rd is gonna be 225 points and so on. On the "angler of the year
sheet", each cell in one column is gonna need this formula. So if, John Brown
takes 1st place then he get's 300 points or if he takes 3rd place then he
gets 225 and so on for each memeber. Can anyone help me. If you need more
info on what I am trying to do then please let me know.

Thanks

--
ketchumbass