software

I have two worksheets, one worksheet has a list of vendors with names and
address using column A to J with address info.

In second worksheet, I have drop down that contains my list of Vendor names.
Is it possible to pick up the address info based on vendor name?Its ok - figured it out - used a vlookup! Thanks.

quot;Well Missyquot; wrote:

gt; I have two worksheets, one worksheet has a list of vendors with names and
gt; address using column A to J with address info.
gt;
gt; In second worksheet, I have drop down that contains my list of Vendor names.
gt; Is it possible to pick up the address info based on vendor name?
gt;

Solved the problem - used vlookup.

quot;Well Missyquot; wrote:

gt; I have two worksheets, one worksheet has a list of vendors with names and
gt; address using column A to J with address info.
gt;
gt; In second worksheet, I have drop down that contains my list of Vendor names.
gt; Is it possible to pick up the address info based on vendor name?
gt;