Yes. I do want column "G" blank. I will try this formula in the morning.
Thank you very much.


Joe




David Biddulph Wrote:
"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


--
JosephWood
------------------------------------------------------------------------
JosephWood's Profile: http://www.excelforum.com/member.php...o&userid=36776
View this thread: http://www.excelforum.com/showthread...hreadid=564916