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]

"JosephWood" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

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


Joe

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

[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 message news:[email protected]...
>
> 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