If statments

L

Lweiss

I have a workbook with 2 spreadsheets, I want to create an if statment that
does the following.....
in workbook 2 cell A,if workbook 2 cell J contains the letter c then put
cell g from workbook c else null....

How can this be done??
 
L

Lweiss

Correction

If workbook 1 cell J contains the letter C then put cell G from workbook 1
in workbook 2 cell a else null.
 
P

Per Jessen

Hi

Assuming that you want to compare values in row 1, try this formula in cell
A1 in sheet2.

=IF(Sheet1!J1="C";Sheet1!G1;"")

Regards,

Per
 
Top