A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formulas that recognise data from two worksheets



 
 
Thread Tools Display Modes
  #1  
Old March 18th, 2010, 04:42 AM posted to microsoft.public.excel.worksheet.functions
Kimbeau
external usenet poster
 
Posts: 1
Default 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  
Old March 18th, 2010, 05:54 AM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.