Help with IF function...

[JosephWood]

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?



Joe

 

[VBA Noob]

What's In I and G ??

Think you need to post more info

This link might help with the comparing Column C in both workbooks

http://www.cpearson.com/excel/duplicat.htm

VBA Noob

 

[David Biddulph]

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?

 

[JosephWood]

Column "I" has either an e-mail address or a fax number. "G" has th
words fax# or e-mail in it.


Joe

 

[JosephWood]

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


Joe

"JosephWood" <[email protected]
wrote
in messag

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'
match, you
want blank in G?