If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formulas that recognise data from two worksheets
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 |
#2
|
|||
|
|||
Formulas that recognise data from two worksheets
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|