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?
Well Missy - 28 Mar 2006 05:26 GMT
Its ok - figured it out - used a vlookup! Thanks.
> 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?
Well Missy - 28 Mar 2006 05:28 GMT
Solved the problem - used vlookup.
> 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?