You could use a formula of

=INDEX($E$2:$E$200,MATCH(J2&K2,$A$2:$A$200&$B$2:$B $200,0))

which is an array formula, committed with Ctrl-Shift-Enter

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

" wrote
in message ...
I am a teacher working with EXCEL. I have a list - 3 classes each
alphabetical, but not with final grades. I want a list - 1 list with
grade
and then alphabetical listing. I am trying to set this up before the
final
grades are list (and subject to change).

The original list has last name (A), first name (B), student ID (C), class
9
thru 12 (D), and I want to put the average in (E).

I am copying CTRL-C and CTRL-V from A-D and moving to G-J and then I tried
in cell K3 the formula =E3 and dragged that down thru the column. When I
sorted G thru K based on J and A and B the K column stayed in the same
order
while the other columns sorted. How do I get the K column to 'sort' like
the other (I) columns did?

I tried the idea of putting a '$' on the number part of the formula, but
I
know that will not drag down. Instead of =E3, I made it =E$3, and that
one
moved but K3 now was still = E3. Is there an easy way to put the dollar
sign
on all (the whole column) ?