Formulas that recognise data from two worksheets

[Kimbeau]

I want to use data that is entered in one worksheet to calculate an equation
in another worksheet. But i want worksheet one data to be recognized and
correlated with data in worksheet two before the calculation happens.
For example if i enter a type of material, the colour and the amount of
metres cut, i want the formula in worksheet two to workout the total metres
left by recognising the type of material and the colour and correlating it
with the material and colour and total amount of material that has been
entered in worksheet two. Reasons is there may be the same material but
different colours and i want the formula to work out how much material is
left over once so many metres have been cut. But i need the information to be
in different worksheets rather than the same one.

i hope someone can help

 

[Fred Smith]

What you're asking for won't be any problem, but you haven't given a lot of
detail. In general, you refer to cells in another worksheet by including the
sheet name in the formula, as in:

=if(sheet1!a1="material1","do this","do that")
=sheet1!a2*sheet1!b2
=vlookup(a1,sheet1!a:b,2,false)

Regards,
Fred