# Formula based on sheet calculations?

Copper Contributor

# Formula based on sheet calculations?

For example, I have one sheet/tab called "Items" with rows for many item names listed in column A, a value in column B, and want to get a result in column C from a calculation.  (there are other things in remaining columns).   Now, in a second sheet called "CalculationWorksheet", I have various tasks listed in column A, and a calculation in column B for each task based on a factor and the input value.  All that is summed up into a result value.

Basic idea of the "Items" Sheet"

A, B, C

item1, 40, "want value from worksheet calculations in 2nd sheet using 40"

item2, 35, "want value from worksheet calculations in 2nd sheet using 35"

etc...

Without doing any Visual Basic formulas (too technical for end user), I'd like to use the "CalculationWorksheet" somehow as a function taking the input value from column B in the first sheet listing items and populate the result value in column C (result) to keep things simple and maintainable.

It's like I'd want to have column c set to "=CalculationWorksheet(B2)" to get the value for C2 and so on for each row.

I don't know what that would be called and am not finding it online.

Is such a thing possible?

2 Replies

# Re: Formula based on sheet calculations?

Another way of stating...
If task 1 was to mail Christmas cards to family, the tasks would be something like "verify address", "put card in envelope", "address it", "put a stamp on it",
If task 2 was to mail cards to friends, same tasks, but different # of people.
If task 3 was to mail cards to coworkers, etc...