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
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
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" <[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
Column "I" has either an e-mail address or a fax number. "G" has the words fax# or e-mail in it.
Joe
Originally Posted by VBA Noob
Yes. I do want column "G" blank. I will try this formula in the morning. Thank you very much.
Joe
Originally Posted by David Biddulph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks