Results 1 to 3 of 3

Match data to first row of duplicate only

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2009
    Location
    Wales UK
    MS-Off Ver
    Excel 2003
    Posts
    26

    Smile Match data to first row of duplicate only

    Hi everyone,

    I'm using index match to bring data into a worksheet. both worksheets in same workbook

    tab SOURCE EmpID, Data1, Data2, Data3 etc
    tab Match EmpID, 1stChoice, 2ndChoice
    The match cell EMPID contains a unique employee ID number. The majority of employees have a single row of data which holds EmpID and 1stChoice but some have a single duplicate row EmpID and 2ndChoice.
    I would like to be able to match Data1, Data2 etc to the first row for each EmpID but not for the duplicate row.
    This is the formula I'm using
    =INDEX(Data1,MATCH(SOURCE!$D3,EmpID,0))
    Excel 2003

    Thank you
    Diddy
    Last edited by NBVC; 07-12-2010 at 09:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1