Auto-fill from Validation List


L

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?
 
Ad

Advertisements

Ad

Advertisements

R

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top