I am lost. I have a list of restaurants. I created a drop down list for these restaurants in a form I want to use. When I click on a restaurant I want to automatically have it fill in three other cells, one for the company number, one for the company name and one for the Restaurant ID. The form is simple and would look something like this:

Steve's Burger Joint Austin
Company Name Restaurant ID
13 Master Restaurant Group 11259


All four of these are in separate columns (G,H,I and J) but I have only made a drop down list of the individual restaurant name to put into this form.
If I pick Steve's Burger Joint Austin from the list, how can I get Excel to automatically fill in 13, Master Restaurant Group and 11259?????

I have tried VLOOKUP, INDEX and MATCH and must be doing something wrong because none of them work.

If anyone can help it would be greatly appreciated.

Steve