Propagate data from a drop down list

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

It is a worksheet and data validation cell

I thank you for your response. I figured it was something simple but I am not an Excel expert and try working on these things from scanning forums online.

I tried something like this at least 20 times and could not get it to work. I guess I am not sure how the second, third and fourth variable work.....You looked up the selection (which was a name you created for the list of restaurants), I am not sure why or what "restaurants", 2, False represent and how they work together. I will have to re-read the Vlookup command.

Thanks Again

I really appreciate your help. I am actually not as dumb as I thought I was. Everything you did worked. I did a couple of samples and it worked and then tried it on my worksheet and it still did not work. Finally I read somewhere online in another location that the first character in the array cannot be a space or a straight ' or curved ' and a couple of other symbols. I went back to the file that was sent to me and the restaurant names all began with a space and a straight ' symbol. I removed those and the vlookup worked like a champ. So the whole time it was some bad characters keeping it from working.

Thanks again for your help

Steve

Just like Breaking Bad