See http://www.contextures.com/xlDataVal02.html for the solution

"jerious" wrote:

I have a worksheet with a bunch of columns of raw data. I want to set up a
combo box on a seperate sheet so I can search by one of the columns (labeled
"zones"). When I click on a zone from the combo box, I would like just
information associated with that zone to appear (like a vlookup or by running
a macro to filter the sheet by that zone). I am not too familiar with combo
boxes so I am having trouble figuring this one out. Thanks