I have two different spreadsheets not evenly put together one is run against an Amazon database utilizing UPC codes and the other one is the actual order form for the product. I need to find the best seller items and the new items and cross reference it with the current sheet I am using. The identifiers for both best seller and new items are a Y how do I cross reference both these sheets? Do I use a VLOOKUP and then and if formula or what? Please help!

Thanks,

Cvolpe