I want to perform a vLookup from a combo box in excel. I have a table of customers that I have linked from Access. I have a combo box that is populated with the customer names from linked table. I want it set up so that when you select a customer it fills in their other information; address, phone, email, etc.
I know how to do a vLookup, but how do I get it to lookup from the combo box?
Any help? Thanks!!