match person with ID # with List

[jay-excel]

Hello,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am trying to create a formula or macro that when a person’s name is chosen from a drop-down list, another cell populates the person’s ID number.
<o></o>
I have two columns.
<o></o>
Column 1 has a list of people
Column 2 has the assigned id of each person
<o></o>
A2 and B2 matches the person and their ID
<o></o>
I then have a dropdown list of all the people.
I want to have another cell populate the person’s id when they are chosen from the drop-down list.
<o></o>
A1 – A5 has a list of people
B1 – B5 has a list of the people’s ID
<o></o>
D4 has a drop-down list of the people
E4 à I want this cell to show the person’s ID

 

[Special-K99]

In E4

=VLOOKUP(D4,A1:B5,2,FALSE)

 

[bruderbell]

Try the vlookup function in cell e4.

=vlookup(d4,a1:b5,2,FALSE)

 

[Matty]

An alternative method:

=INDEX($B$1:$B$5,MATCH($D$4,$A$1:$A$5,0))

Matty

 

[jay-excel]

Great help everyone, thank you very much!
---

What are the differences between:

=VLOOKUP() & =INDEX(,MATCH())

 

[Matty]

Hello jay-excel,

One big advantage that INDEX/MATCH has over VLOOKUP is that it doesn't rely on the lookup_value (in the table_array) having to be in the first Column. Other than that, it's pretty much personal preference.

This link may be useful:

http://contextures.com/xlFunctions03.html

Matty