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