Use Vlookup to use formula calculation from another sheet

Hello

I would like to use a Vlookup type funtion for Sheet1 by Items that looks into Sheet2 Items column and use the formula within the Result column from Sheet2 of the matching item and use that formula for Sheet1 Items.

I attached the result.

As you see on Sheet1 it's the same formula calculation for each item as in Sheet2. I want a Vlookup by Item type formula that would look into Sheet2 and do the same formula from Sheet2 onto Sheet1.

I have a very long list of products which each has a different formula calculation requirement (that are the same from last year) and don't want to do it manually.

Thank you,

I try to do something like that using evaluate formula but it only did exactly what the formula said.

Example: Sheet2 for product pen would have B14/3
Sheet1 Would do the same formula B14/3 : But I would need it to be B2/3

Originally Posted by JohnTopley

I suggest what you need is table with the DIVISORS for each product (3,4,6,60,80,400 etc)

so C2

=B2/VLOOKUP(Product,Table,2,0)

Where table has Products in one column (X) and its divisor in the next column Y)

so table: X2:Y100

Some of them is not only equations some has other type of formula related to the product could be a if statement a vlookup too or simple equation as shown on the attachment.

Originally Posted by oeldere

With vlookup.

See the green cells in the attached file.

oeldere,

I greatly appreciate the help but some of the product requirement is not only equations some has other type of formula related to the product could be a if statement a vlookup too or simple equation as shown on the attachment could be division multiplication addition subtractions.

You will need VBA to do this.