Edited the entire request to make it easier.
How do you use vlookup to return a data validation list?
Ex:
Sheet1
(A1) Company Name (B1) Contact Name 1 (B2) Contact Name 3 (B3) Contact Name 4
Sheet2
(A1) <enter company name> (B1) Drop down list with Sheet1 B1,B2,B3 appears
Thank you.
Bookmarks