highest number formula

right i have a little spreadsheet. row A has 9 names from a2 to a10
in column b this has some various scores taken from another part of the spreadsheet......so b2=10 b3 = 15 etc

what i would like my spreadsheet to do is to check through the numbers to see which is the highest number which would make the name corresponding to that number be in 1st place on another part of the sheet........

i can get the first 8 numbers to work with names but as soon as i add a 9th if function then i get an error.....

can someone tell me where i am going wrong or could they suggest a better funtion than IF

C SHIFT PUNDITS
bob 13
bob1 14
bob 8
bob2 17
bob 15
bob3 18
bob 12
bob4 9
bob 9


bob 5 1ST FALSE
bob1 4 2ND
bob 9 3rd
bob2 2 4th
bob 3 5th
bob3 1 6th
bob 6 7th
bob4 7 8th
bob 7 9th

=IF(B13=1,A13,IF(B14=1,A14)) and so on but when i get to if (b21=1,a21) i get the error and i cant get past it

thanks

rod

thanks for that


works like a charm