Correction

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



"Lweiss" wrote:

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??