PDA

View Full Version : Solved: Help with Excel roster matching...



jayploc
09-30-2008, 08:24 AM
Hello,

I've posted a few questions similar to this, but this one is slightly different and I cannot figure it out.

I have a workbook with 2 sheets. Sheet 1 has 3 seperate sections for a biology class, sorted by last name and containing a blank column for "Exam 1". In sheet 2 is a list of all of biology test scores containing ALL of the students in one list.

I want to match them by last/first name and fill in the Test 1 score in the 3 columns marked for it in sheet 1.

If anyone can help me with a code I would appreciate it.
Thanks.

xld
09-30-2008, 08:37 AM
=INDEX(Sheet2!$D$3:$D$1248,MATCH(1,(Sheet2!$A$3:$A$1248=B3)*(Sheet2!$B$3:$B $1248=C3),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually.
When editing the formula, it must again be array-entered.

jayploc
09-30-2008, 09:11 AM
Ok that works, thanks a lot.