@Twifoo all the SKUs, on hand, prices, ect are in a standard list format on the "PEXTRACT" tab. this is what is pulled from our back office reports for all product information. The goal is that if i am not here to handle the planograms a person could simply pull a report and paste it in that tab to get the order numbers needed.
The formula doesn't have to be an index match, that is just what i thought i needed. The planograms have to stay within the format they are because that is what is printed to pdf and sent to each store so they can set up their walls (and that's the way the higher ups want it laid out as well). What i am essentially doing is cross checking the "PEXTRACT" to the planogram and pasting the "true" result skus (without duplicates) in column A:A of the ordering sheet.
If there still isn't a way to get the needed information with those tabs i will start working on a UDF that will do what i need. I just didn't want to have to go that route since UDF's always run into problems when the workbook is sent to another PC in my experience.
