Auto-fill from Validation List

[Ledford]

I'm working with a big vendor list of where names are in one column,
followed by address, city, state, zip, phone, etc in adjacent
columns. In a different sheet in the same workbook, I've figured out
how to create a dropdown where I select the name from the list using
Data Validation. How do I set it up to auto-fill the remaining data
that corresponds to the name in other cells?

 

[Don Guillett]

Tie it to a worksheet_change event in the sheet module or use vlookup

 

[Rich/rerat]

Ledford,
You can use a VLOOKUP formula to fill-in from the master list, the other
cells in the row.

VendorList is the range of your vendor list

In Column A your Dropdown List.
In Cell B2: =IF($A2="","",VLOOKUP($A2,VendorList,2,0))
In Cell C2: =IF($A2="","",VLOOKUP($A2,VendorList,3,0))
In Cell D2: =IF($A2="","",VLOOKUP($A2,VendorList,4,0))
And so on.
Drag the VLOOKUP formula down the respective columns as needed.
--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


I'm working with a big vendor list of where names are in one column,
followed by address, city, state, zip, phone, etc in adjacent
columns. In a different sheet in the same workbook, I've figured out
how to create a dropdown where I select the name from the list using
Data Validation. How do I set it up to auto-fill the remaining data
that corresponds to the name in other cells?