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