Prev: How do I find a value in a table without using the labels?
Next: Degrees Minutes Decimal Minutes to Decimal Degrees.
From: Kimbeau on 17 Mar 2010 23:42
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
From: Fred Smith on 18 Mar 2010 00:54
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

"Kimbeau" <Kimbeau(a)discussions.microsoft.com> wrote in message
news:FCE35208-D75A-4A52-A664-A1AD795E8418(a)microsoft.com...
>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

 | 
Pages: 1
Prev: How do I find a value in a table without using the labels?
Next: Degrees Minutes Decimal Minutes to Decimal Degrees.