Drop down list question..

[plasma]

I have one sheet with the following info:

            A                   B                       C

1       Name                Company            Contact Number
2
3       John               Company A            555-555-1234
4       Eric                Company B            555-555-5555

I would like to create a drop down list (on another Sheet), where when I select a person's name, it will automatically fill in their company name and contact #.

I know how to create the drop down lists, but I'm not sure how to connect the company name and phone number when the person is selected.

any easy way to do this?

 

[qafself]

You can do this using Vlookup

see the attached example

Ed