Formula help

[Miguelluis]

I wander if you can help with the below:

I have an ingredient list on a sheet

INGREDIENT	PACKAGE SIZE	COST	SERVING SIZE PER CONTAINER	TOTAL	COST PER UNIT
cereal hoops (3 x 586 box)	1.53	kg	£11.89	1	tablespoon	102	102	£0.12	tablespoon
marshmallows	500	grams	£2.99	1	corn	30	30	£0.10	corn
bagel (2 x 6 pack)	12	bagels	£2.99	1	portion (1/2 bagel)	24	24	£0.12	portion (1/2 bagel)

<tbody>
</tbody>

Then on other sheets I will have, recipes:

What I need here is when you populate column A with an ingredient on the range above, to then pull the corresponding cost per unit above:

INGREDIENT	RECIPE	COST PER UNIT	COST FOR RECIPE
cereal hoops (3 x 586 box)	175	grams	#DIV/0!	0	#DIV/0!
marshmallows	300	grams	#DIV/0!	0	#DIV/0!
unsalted butter	50	grams	#DIV/0!	0	#DIV/0!

<tbody>
</tbody>

I've tried this but it doesn't work - =IF(A2,'Ingredients list'!A3:A80,'Ingredients list'!I2:I80)

Any help is appreciated

Thank you

 

[VoG]

Try Excel VLookup Function Examples

 

[Miguelluis]

Try Excel VLookup Function Examples

Hi

It worked a treat, thanks.