Auto Populate Based on Drop Down Selection.

[richmcgill]

How would I do this? I am not using Visual Basic.

I have form and I am trying to auto populate other fields based on the selection in a combo box. I tried VLookups but they will not recognize the data in the drop down box. I have a separate tab with all of the sales peoples name and other information. A1:A25 Salespersons Name B1:B25 Salespersons Telephone number C1:C25 Sales Persons Assistants Name What I need is a way to pull in the information based on the sales person selected A1 Combo Box with list of sale people’s names and select one sales person’s name and the next two will auto populate with the correct information. A2 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information A3 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information I am trying to auto populate other fields based on the selection in a combo box. I tried VLookups but they will not recognize the data in the drop down box. I have a separate tab with all of the sales peoples name and other information. A1:A25 Salespersons Name B1:B25 Salespersons Telephone number C1:C25 Sales Persons Assistants Name What I need is a way to pull in the information based on the sales person selected A1 Combo Box with list of sale people’s names and select one sales person’s name and the next two will auto populate with the correct information. A2 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information A3 Based on what is selected in A1 will pull the salespersons telephone number from the other tab of information

<tbody>
</tbody>