Help with IF function...

J

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
 
D

David Biddulph

JosephWood said:
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?
Click to expand...

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

JosephWood

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


Joe
 
J

JosephWood

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


Joe




David said:
"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?
Click to expand...

=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?
Click to expand...
 
Top