Return a value based on a condition

[uberathlete]

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.

[oeldere]

with an pivot table.

see the attached file.

[Melvinrobb]

The attached file is similiar to oeldere, but with a formula in column G to display the source. You can then hide columns C:E, and get the list structured how you wanted it.

[oeldere]

@Melvinrobb

Great solution

I'm interested how you get your index / match formula in column G.

If I try that i get GETPIVOTDATA in my formula.

[Melvinrobb]

Not entirely sure I get what you mean, but I think I do.
Instead of manually clicking on the cell, actually type in F5 (or whatever cell/range you want to reference).
You should never have to change the ranges, as each formula simply references the individual row, but you will have to drag the formula down dependant on the number of rows of the pivot table.

[oeldere]

Instead of manually clicking on the cell, actually type in F5 (or whatever cell/range you want to reference).

This one did the trick.

How easy can an solution be (if you know the answer).

Thanks very much for lighting this up for me.

Point of rep. goes your way.

[uberathlete]

Awesome. Thank you Melinrobb and oeldere!