Using Index/Match to return a specific value with a condition

[kslattery]

I've got a pretty straightforward database where each row represents a unique entry. My primary key is an identification number, which can be repeated if the participant has multiple entries. Each entry has a unique value, and I'm trying to find an easy way to generate a formula which returns only the value in column C for entry #1 by each participant.

So even though Participant 123 has three entries, I want the value in column D (highlighted) to always represent what's in C2. It seems like I could use IndexMatch to get what I need here, but I'm having trouble connecting the dots.

maniNql.png

[Pete_UK]

Put this in D2:

=VLOOKUP(A2,A:C,3,0)

then copy down to the bottom of your data.

Hope this helps.

Pete

[bebo021999]

Here it is

Capture.JPG

[kslattery]

Thanks -- didn't think to use VLOOKUP within the same table!

[kslattery]

Here it is

Attachment 605685

I tried this, but ended up getting a "value not available" error for ID 44 when I entered the formula.