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?
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.
One test is worth a thousand opinions.
Click the * below to say thanks.
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,
Hari
"Trying to find excel boundaries"
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.
One test is worth a thousand opinions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks