Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Funtion between worksheets
I am now trying to do this basic function.
If C5 from worksheet 3 is this, than C4 from the same worksheet is this. and put this info into worksheet 1 two different cells. Help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Funtion between worksheets
Try this in the this first workbook
=IF([Book3]Sheet1!$C$5=100,[Book3]Sheet1!$C$4) "Lisa" wrote: I am now trying to do this basic function. If C5 from worksheet 3 is this, than C4 from the same worksheet is this. and put this info into worksheet 1 two different cells. Help!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Funtion between worksheets
On Sheet 3 C4 enter the following formula where X represents the value to
test for in C5 and Y is the value to be returned if the test is True: =If(C5=X,Y) If C5 doesn't equal X cell C4 will be left empty. You could carry it one step further to have C4 display something else (Z) if C5 doesn't equal X (the test is False): =If(C5=X,Y,Z) In each of the cells on Sheet 1 where you want the Sheet3!C4 value to appear, do the following: Select the cell, type =, then click the tab for Sheet3 & select cell C4, press Enter. The result will be: =Sheet3!C4 which you could type if you prefer rather than using the mouse. -- HTH |:) Bob Jones [MVP] Office:Mac "Lisa" wrote in message ... I am now trying to do this basic function. If C5 from worksheet 3 is this, than C4 from the same worksheet is this. and put this info into worksheet 1 two different cells. Help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Merge Worksheets | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |