Updating formulas in other sheets after sorting A-Z

[kparis326]

Hi I'm quite new to Excel,

I'm costing recipes and have made this ingredient sheet to reference.

When I sort the table A-Z all the data sorts it self correctly on this sheet but when I go to a recipe sheet any formula referencing the D column doesn't update, it stays as the same column as before. Is there a way to make it update across all the sheets without having to do it manually?

Thank you

 

[Kerryx]

What formula is in the recipe sheet to link to the price/kg

 

[kparis326]

It looks like this

 

[jtakw]

Hi,

Try this formula in your recipe sheet, change/adjust cell range/references accordingly:

=B3*VLOOKUP(A3,Ingredientlist!A$2:D$100,4,0)