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
<?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