base autofilter off droplist

[Josh]

how to i make an autofilter go off a dropdown list
or can i cause a list to filter using the dropdown list i.e.

if i have (one, two, three) in a dropdown I pick two
the list will show only the rows that have "two" in them