I'm new on google spreadsheets, and I'm having this little problem:

I want to create a project manager with an external spreadsheet just for customer-info. In my "main-hub" sheet, I have created a dropdown menu on B11 which copys the customer names from the extrenal sheet. That works fine.

Now the problem I am trying to solve: I want to keep the drop-down menu on B11, i dont want to add any new drop down menus. Whenever I select an item from the menu on B11, additional information about the customer should be inserted into different cells in different columns. Example:

| \_\_\_\_\_\_\_\_\_\_ B11 \_\_\_\_\_\_\_\_\_\_ | \_\_\_\_\_\_\_\_\_\_ J11 \_\_\_\_\_\_\_\_\_\_ | \_\_\_\_\_\_\_\_\_\_ K11 \_\_\_\_\_\_\_\_\_\_ |

```
        Selected Name         dynamicly inserted data 1      dynamicly inserted data 2   

```

Please keep in mind, I really don't want to add any new drop down menu, I want to keep only this one for the names of the customers.