Thread: look up combo box EXCEL 2010 problem

Hi people!
I have a problem with using a combo box in Excel 2010.
I have created two combo box. One of them is displaying a list of location while another one is displaying a list occupation.
I need to display results from a an employee table when user selects both of the options from the combo box.
How do I do that? I can't read the value stored inside combo box.
Thanks !