I need to use a Combo Box that will be the entries for a VLOOKUP (I think)
function.

I need someone to make choices by using a Combo Box and this may be 1 - 3
separate entries for this fomula and once these choices are made to hit a
search button for it to return a list of information from the list with only
the specific driteria.

I need to know how to get the Combo Box to get the list of values from the
Datasheet (preferrably with only unique values) so someone only sees in the
list one entry instead of multiple duplicate entries.

After this is accomplished I will have up to 3 of these Combo Boxes that
will be the entries for an eventual listing of only those items that meet
that criteria from the Combo Box choices.

Please no reference to Auto Fill. I need this to operate closely to how
I've described it above.

Dave French