Formula help

[Miguelluis]

I wander if you can help with the below:

I have an ingredient list on a sheet

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="width: 253"]INGREDIENT[/TD]
[TD="width: 157, colspan: 2"]PACKAGE SIZE[/TD]
[TD="width: 55"]COST[/TD]
[TD="width: 185, colspan: 3"]SERVING SIZE PER CONTAINER[/TD]
[TD="width: 54"]TOTAL[/TD]
[TD="width: 190, colspan: 2"]COST PER UNIT[/TD]
[/TR]
[TR]
[TD="width: 253"]cereal hoops (3 x 586 box)[/TD]
[TD="width: 39"]1.53[/TD]
[TD="width: 118"]kg[/TD]
[TD="width: 55"]£11.89[/TD]
[TD="width: 18"]1[/TD]
[TD="width: 135"]tablespoon[/TD]
[TD="width: 32"]102[/TD]
[TD="width: 54"]102[/TD]
[TD="width: 55"]£0.12
[/TD]
[TD="width: 135"]tablespoon
[/TD]
[/TR]
[TR]
[TD]marshmallows[/TD]
[TD]500[/TD]
[TD]grams[/TD]
[TD]£2.99[/TD]
[TD]1[/TD]
[TD]corn[/TD]
[TD]30[/TD]
[TD="width: 54"]30[/TD]
[TD="width: 55"]£0.10[/TD]
[TD="width: 135"]corn[/TD]
[/TR]
[TR]
[TD]bagel (2 x 6 pack)[/TD]
[TD]12[/TD]
[TD]bagels[/TD]
[TD]£2.99[/TD]
[TD]1[/TD]
[TD]portion (1/2 bagel)[/TD]
[TD]24[/TD]
[TD="width: 54"]24[/TD]
[TD="width: 55"]£0.12[/TD]
[TD="width: 135"]portion (1/2 bagel)[/TD]
[/TR]
</tbody>[/TABLE]

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:
[TABLE="class: grid, width: 542"]
<tbody>[TR]
[TD]INGREDIENT[/TD]
[TD="colspan: 2"]RECIPE[/TD]
[TD="colspan: 2"]COST PER UNIT[/TD]
[TD]COST FOR RECIPE[/TD]
[/TR]
[TR]
[TD]cereal hoops (3 x 586 box)[/TD]
[TD="align: right"]175[/TD]
[TD]grams[/TD]
[TD="align: center"]#DIV/0!
[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]marshmallows[/TD]
[TD="align: right"]300[/TD]
[TD]grams[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD]unsalted butter[/TD]
[TD="align: right"]50[/TD]
[TD]grams[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
</tbody>[/TABLE]

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.