Create Reference from a cell formula

0

Hi!

I have a program on excel to calculae recipes and ice cream items,

so in sheet 1 I have a Ingredients list with all ingredients and the prices,

now in sheet 2 I have the colculation for the resipes, and then I put the name of the recipe in sheet 1 in column A like a ingredient and the price in column B,

now what i want to do is, Instad to rerence the cell in column A to the title of the recipe, and the cell in column B to the price of the recipe, I want when I reference the cell in column A, should the cell in column B be equals to where the cell in column A is referenced, and then a OFFSET function to the cell of the price,

like this

lat's say, the title name of the recipe is in cell E1, so in A1 I make =E1,
and in H20 is to total price of the recipe, so in B1 I make =H20,
so what i want is, instead to make in B1 =H20 I want it should go automatically, so in B1 I put something like this =IF(A1=E1,OFFSET(E1,19,3),"")
but I want where ever A1 is linked, should B1 be linked to the same cell with a OFFSET(?,19,3)

Discussion

This sounds like a task for VLOOKUP, not OFFSET. Read up on the function, but if that doesn't solve your problem please post a mockup of your workbook so that we can see where the data are.
Variatus (rep: 1433) Aug 7, '17 at 8:29 pm

0

I put this in B1 and I got the price for which recipe is in A1

=OFFSET(INDEX(sheet2!E1:E2000,MATCH(A1,sheet2!E1:E2000,0)),19,3)

0

I don't think I quite understand this question.... just go to sheet 2 in cell B1 and type = and then go to sheet 1 and click cell A9 and hit Enter.

Discussion

lat's say, the title name of the recipe is in cell E1, so in A1 I make =E1,
and in H20 is to total price of the recipe, so in B1 I make =H20,
so what i want is, instead to make in B1 =H20 I want it should go automatically, so in B1 I put something like this =IF(A1=E1,OFFSET(E1,19,3),"")
but I want where ever A1 is linked, should B1 be linked to the same cell with a OFFSET(?,19,3)
JAExcel (rep: 10) Aug 7, '17 at 5:45 pm