I have sheet one which is column "A" student's name columns "B thru K" are a
point system in each column (by 3 points either a score of 1, 2 or 3).
Column "L" is the total points summed across "B" thru "K". (a total of no
more than 30).

Sheet 2 is 5 columns with each column being worth 6 points. Column "A" is
25 thru 30 points, column "B" is 19 thru 24 points, column "C" is 13 thru 18
points, column "D" is 7 thru 12 points and column "E" is 0 thru 6 ponts.

I need column "L" on sheet one to move the students name on that row to
sheet 2 into the appropriate column based on his/her respective score.

The formulas you want for columns A to E in Sheet2 a
=IF(AND(Sheet1!$L1=25, Sheet1!$L1<=30), Sheet1!$A1, "")
=IF(AND(Sheet1!$L1=19, Sheet1!$L1<=24), Sheet1!$A1, "")
=IF(AND(Sheet1!$L1=13, Sheet1!$L1<=18), Sheet1!$A1, "")
=IF(AND(Sheet1!$L1=7, Sheet1!$L1<=12), Sheet1!$A1, "")
=IF(AND(Sheet1!$L1=0, Sheet1!$L1<=6), Sheet1!$A1, "")

Cheers,
Rob


On 14-Dec-2009 19:20, vaughn01 wrote:
I have sheet one which is column "A" student's name columns "B thru K" are a
point system in each column (by 3 points either a score of 1, 2 or 3).
Column "L" is the total points summed across "B" thru "K". (a total of no
more than 30).

Sheet 2 is 5 columns with each column being worth 6 points. Column "A" is
25 thru 30 points, column "B" is 19 thru 24 points, column "C" is 13 thru 18
points, column "D" is 7 thru 12 points and column "E" is 0 thru 6 ponts.

I need column "L" on sheet one to move the students name on that row to
sheet 2 into the appropriate column based on his/her respective score.