If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kevin K" wrote in message
...
I have a list of thousands of UPCs with the category name in adjacent
cells.
I need to build a formula to automatically populate a list of UPCs based
on
the category selected in another worksheet in the workbook. The category
selection is already automatically selected from data that is imported in
another worksheet in the workbook.

This seems like it should be very simple, but I can't find anything online
that provides a simple way to do it. I only find manual ways to do it.

Thanks for any help out!
Kevin K