Consulting

Results 1 to 3 of 3

Thread: Solved: Help with Excel roster matching...

  1. #1
    VBAX Regular
    Joined
    Jun 2008
    Posts
    18
    Location

    Solved: Help with Excel roster matching...

    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.
    Last edited by jayploc; 09-30-2008 at 08:25 AM. Reason: forgot to attach file

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,149
    Location
    =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.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Jun 2008
    Posts
    18
    Location
    Ok that works, thanks a lot.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •