Help with IF function...
 

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


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

Help with IF function...
 

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


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

Help with IF function...
 

"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

Help with IF function...
 

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


Joe





VBA Noob Wrote:
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
------------------------------------------------------------------------
JosephWood's Profile: http://www.excelforum.com/member.php...o&userid=36776
View this thread: http://www.excelforum.com/showthread...hreadid=564916

Help with IF function...
 

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