How to bring back a particular column

[alethea2000]

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

 

[shaowu459]

do you mean this

Book2
	A	B	C	D	E	F	G	H	I
1	Ingredient	Tescos	Sainsburys	Aldis	Lidls		cheese	Sainsburys	0.7
2	cheese	0.6	0.7	0.45	0.5
Sheet3

Cell Formulas
Range	Formula
I1	I1	=VLOOKUP(G1,A:E,MATCH(H1,A1:E1,),)

 

[Fluff]

Another option

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I
1	Ingredient	Tescos	Sainsburys	Aldis	Lidls			Sainsburys	Lidls
2	cheese	0.6	0.7	0.45	0.5		cheese	0.7	0.5
3	Tomato	0.5	0.6	0.35	0.45		tomato	0.6	0.45
4
Lookup

Cell Formulas
Range	Formula
H2:I3	H2	=INDEX($B$2:$E$10,MATCH($G2,$A$2:$A$10,0),MATCH(H$1,$B$1:$E$1,0))

 

[alethea2000]

thank you all so much

 

[alethea2000]

do you mean this

Book2
	A	B	C	D	E	F	G	H	I
1	Ingredient	Tescos	Sainsburys	Aldis	Lidls		cheese	Sainsburys	0.7
2	cheese	0.6	0.7	0.45	0.5
Sheet3

Cell Formulas
Range	Formula
I1	I1	=VLOOKUP(G1,A:E,MATCH(H1,A1:E1,),)

what are the spare commas at the end

 

[alethea2000]

=VLOOKUP(G1,A:E,MATCH(H1,A1:E1,),) - I can get my head around this but would like to understand the ,),) if possible, thank you

 

[shaowu459]

It s

what are the spare commas at the end

It should be ",0". However, you can use a comma instead.

 

[alethea2000]

thank you

 

[alethea2000]

ooo I just explored an xlookup too,