Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word07 won't recognise updated data from MSExcel07 | Excel Discussion (Misc queries) | |||
How can I get Pivot Tables to recognise time formatted data | Excel Discussion (Misc queries) | |||
getting excel to recognise copied data as mm:ss not hh:mm | Excel Worksheet Functions | |||
Having to Press F2 to recognise data from another sheet in Excel | Excel Discussion (Misc queries) | |||
After concatenating data, how do I get Excel to recognise date? | Excel Discussion (Misc queries) |