Autofill a cell based on selection in drop down menu

**fyrfytr265** · 01-13-2012, 12:21 AM

I have 3 cells used for Vendor Name, Street Address and City/State/Zip. The top cell I created a drop down menu with all vendor names. How do I go about making the Street Address and City/State/Zip cells fill in based on which vendor I choose?

**MarvinP** · 01-13-2012, 12:46 AM

Hi fyrfytr265,

I'd make a table of all my vendors with 5 columns. Vendor Name, Address, City, State, Zip.

Then in another section I'd have a dropdown of all Vendor Names and I'd select one of them. Then use VLookup of the dropdown cell to find the Address, City, etc.

See attached for a simple example.

**reachhari** · 01-13-2012, 01:23 AM

Hi Both,

I believe there should be small correction in the formula listed in your workbook. Corrected and attached it, please refer to it.

Thanks,

**MarvinP** · 01-13-2012, 11:42 AM

Hi reachhari,

It looks like I used "Column()" in my formula and you put in a reference for the column, like "Column($B1)".
In reading http://office.microsoft.com/en-us/ex...010062409.aspx
the column reference is OPTIONAL and not needed if your are returning the column number of the formulas' column.

**Kelli421** · 01-30-2014, 10:35 AM

I am unable to get the VLookup formula to work for me.

I have the DC names I need listed on the left hand side and have made a drop down list of this selection. When I am then trying to have it auto fill the cells beneath with the addresses linked to each DC name it continues to tell me that my value is incorrect.