One way would be to set a macro and assign it to a custom button that would
activate the AutoFilter, using your ActiveCell value as the criteria. (Then
a second button, probably, that would reset your list to "before filter".)

HTH
Ed

"Vita Cator" wrote in message
...
I would like to create a price list that will show me
results for a specific selection. For example, I would
like to chose a price and have it automatically bring up
the description and any other fields that are only
applicable to that selected item. Any idea the best way I
should approach this??