Hi everyone. I am in dire need of help. Please see attached.
In the Min Prices sheet, ingredients are listed. I would like the minimum prices of these ingredients and the corresponding source to show in their appropriate columns, based on the data in the Ingredients List sheet.
Does anyone know if this can be done with Pivot Tables, or some other method?
Any assistance would be much appreciated.
Bookmarks