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?