I have two named lists, one containing vendor names and the other containing
vendor numbers. When a user selects a vendor name from the drop down box in
column B I would like the vendor number to populate in column A. How do I do
this?