alethea2000
Board Regular
- Joined
- Nov 27, 2003
- Messages
- 67
We are trying to price up our recipes.
so lets just use this as an example
We have one list that says the ingredients and then many columns with how much the ingredient costs from all the different places we buy it from
Ingredient. Tescos. Sainsburys. Aldis. Lidls
cheese. 0.60. 0.70. 0.45. 0.50
then in another sheet I will have a recipe
so
cheese. Sainsbury's.
how can I get.a formula to say lookup cheese and if it matches what is in b2 bring back the ssainsburys spice but if it says Aldi bring back the Aldi price. I hope this makes sense, I'm thinking maybe if and vlookups and someone mentioned an xlookup but I don't thing this would be it. Thank you all
so lets just use this as an example
We have one list that says the ingredients and then many columns with how much the ingredient costs from all the different places we buy it from
Ingredient. Tescos. Sainsburys. Aldis. Lidls
cheese. 0.60. 0.70. 0.45. 0.50
then in another sheet I will have a recipe
so
cheese. Sainsbury's.
how can I get.a formula to say lookup cheese and if it matches what is in b2 bring back the ssainsburys spice but if it says Aldi bring back the Aldi price. I hope this makes sense, I'm thinking maybe if and vlookups and someone mentioned an xlookup but I don't thing this would be it. Thank you all