"JosephWood" wrote
in message ...

I need to create an IF function that compares column "C" of two
workbooks and if they are the same(contains the same information) then
copy the contents of cell "I" to the first workbook in cell "G". Can
anybody help me?

=IF(C1=[Book2]Sheet1!$C$1,IF(I1<"",I1,""),"")

I assume that if cell I is blank, or if the column C values don't match, you
want blank in G?
--
David Biddulph