match? lookup?

[Guest]

Here's a copy of my worksheet
FULLNAME STUDENTID Column3
Ace Elizabeth 000-00-0000 Ace Elizabeth
Alece Stephanie 111-11-1111 Ace Elizabeth
Alvis Gina M 000-00-0001 Amalo Michelle
Amalo Michelle 111-11-1112 Amalo Michelle
Amino Chelsea 000-00-0002 Amalo Michelle
Anima Caitlyn 111-11-1113 Amalo Michelle
Andoe Heidi 000-00-0003 Anima Caitlyn
Andoe Katie 111-11-1114 Anima Caitlyn
Andoe Krista 000-00-0004 Arroe Amy
Andoes Katie 111-11-1115 Arroe Amy
Antunes Alicia 000-00-0005 Arroe Amy
Apple Katie 111-11-1116 Asess Nicole
Armoe Jacy 000-00-0006 Asess Nicole
Arroe Amy 111-11-1117 Asess Nicole
Asess Nicole 000-00-0007 Asess Nicole

FULLNAME has each person's name once (sorted alphabetically); STUDENTID is a unique identifier (which I made up for this question rather than use the real one!), and "Column 3" has a list of names, sorted alphabetically, but which has names repeated several times. Here's what I want to do: I need to leave "Col. 3" as is (duplicates+ and all), but I wonder if there's a way I might associate the STUDENTID with each of those repeated values in Col. 3. The student ID is the "key" in a database.

So, for example, I'd have "Column 3" and "Col. 4"

Ace Elizabeth 000-00-0000
Ace Elizabeth 000-00-0000
Amalo Michelle 111-11-1111
Amalo Michelle 111-11-1111
Amalo Michelle 111-11-1111
Amalo Michelle 111-11-1111

Help? I tried MATCH, but kept getting hung up with the repeating values. so. . .help this long-term neophyte?

 

[Anders Silven]

One way, using VLOOKUP(),

In D2 enter
=VLOOKUP(C2,$A$2:$B$16,2,FALSE)
and fill down the formula in column D.

Result:

FULLNAME STUDENTID Column3 Column4
Ace Elizabeth 000-00-0000 Ace Elizabeth 000-00-0000
Alece Stephanie 111-11-1111 Ace Elizabeth 000-00-0000
Alvis Gina M 000-00-0001 Amalo Michelle 111-11-1112
Amalo Michelle 111-11-1112 Amalo Michelle 111-11-1112
Amino Chelsea 000-00-0002 Amalo Michelle 111-11-1112
Anima Caitlyn 111-11-1113 Amalo Michelle 111-11-1112
Andoe Heidi 000-00-0003 Anima Caitlyn 111-11-1113
Andoe Katie 111-11-1114 Anima Caitlyn 111-11-1113
Andoe Krista 000-00-0004 Arroe Amy 111-11-1117
Andoes Katie 111-11-1115 Arroe Amy 111-11-1117
Antunes Alicia 000-00-0005 Arroe Amy 111-11-1117
Apple Katie 111-11-1116 Asess Nicole 000-00-0007
Armoe Jacy 000-00-0006 Asess Nicole 000-00-0007
Arroe Amy 111-11-1117 Asess Nicole 000-00-0007
Asess Nicole 000-00-0007 Asess Nicole 000-00-0007

HTH
Anders Silven

Here's a copy of my worksheet
FULLNAME STUDENTID Column3
Ace Elizabeth 000-00-0000 Ace Elizabeth
Alece Stephanie 111-11-1111 Ace Elizabeth
Alvis Gina M 000-00-0001 Amalo Michelle
Amalo Michelle 111-11-1112 Amalo Michelle
Amino Chelsea 000-00-0002 Amalo Michelle
Anima Caitlyn 111-11-1113 Amalo Michelle
Andoe Heidi 000-00-0003 Anima Caitlyn
Andoe Katie 111-11-1114 Anima Caitlyn
Andoe Krista 000-00-0004 Arroe Amy
Andoes Katie 111-11-1115 Arroe Amy
Antunes Alicia 000-00-0005 Arroe Amy
Apple Katie 111-11-1116 Asess Nicole
Armoe Jacy 000-00-0006 Asess Nicole
Arroe Amy 111-11-1117 Asess Nicole
Asess Nicole 000-00-0007 Asess Nicole

FULLNAME has each person's name once (sorted alphabetically); STUDENTID is a

unique identifier (which I made up for this question rather than use the real
one!), and "Column 3" has a list of names, sorted alphabetically, but which has
names repeated several times. Here's what I want to do: I need to leave "Col.
3" as is (duplicates+ and all), but I wonder if there's a way I might associate
the STUDENTID with each of those repeated values in Col. 3. The student ID is
the "key" in a database.

So, for example, I'd have "Column 3" and "Col. 4"

Ace Elizabeth 000-00-0000
Ace Elizabeth 000-00-0000
Amalo Michelle 111-11-1111
Amalo Michelle 111-11-1111
Amalo Michelle 111-11-1111
Amalo Michelle 111-11-1111

Help? I tried MATCH, but kept getting hung up with the repeating values. so.

.. .help this long-term neophyte?

 

[Guest]

Thank you! That's swell! I appreciate your help very much.

dep

 

[Anders Silven]

Thank you! That's swell! I appreciate your help very much.

Thanks for the feedback. Glad it helped.

Anders Silven