Funtion between worksheets

L

Lisa

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!!
 
C

CyberTaz

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.
 
Top