DropDown Menu
 

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?

DropDown Menu
 

Its ok - figured it out - used a vlookup! Thanks.

"Well Missy" wrote:

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?

DropDown Menu
 

Solved the problem - used vlookup.

"Well Missy" wrote:

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?