Formula Help - Index Match

[akvpv6]

Happy Wednesday,

I am looking for a formula that will auto-fill the Goal for a User ID when their name is selected from a drop down list. On the attached image you will see I have a table with Person 1-7 and their goal and a table to the right.

I want to insert a formula in the Goal column that will automatically pull in the persons goal from the table. (for example if I select Person 1 from the drop down then the goal would populate with 18)

Thank you!

 

[Fluff]

How about

=INDEX($B$2:$B$10,MATCH([@[User ID]],$A$2:$A$10,0))

 

[akvpv6]

How about

=INDEX($B$2:$B$10,MATCH([@[User ID]],$A$2:$A$10,0))

This seems to be working perfectly, I greatly appreciate the quick and efficient help!

 

[Fluff]

You're welcome & thanks for the feedback.