Help with IF function...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JosephWood - 25 Jul 2006 22:16 GMT

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

Signature

JosephWood

Reply to this Message

VBA Noob - 25 Jul 2006 22:27 GMT

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

Signature

VBA Noob

Reply to this Message

JosephWood - 26 Jul 2006 03:22 GMT

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

Joe

VBA Noob Wrote:

> What's In I and G ??
>
[quoted text clipped - 5 lines]
>
> VBA Noo

Reply to this Message

David Biddulph - 25 Jul 2006 22:36 GMT

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

Signature

David Biddulph

Reply to this Message

JosephWood - 26 Jul 2006 03:24 GMT

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

Joe

David Biddulph Wrote:

> "JosephWood" <JosephWood.2bisbi_1153862412.6202@excelforum-nospam.com
> wrote
[quoted text clipped - 13 lines]
> --
> David Biddulp

Reply to this Message