If A2 is found in Column G then insert the value of D2 into J2

e.g.,

If A2 is found at G50, then insert the value of D50 into J50

where
A = Address1 and G = Address 1 and D = Zip and J = Zip copied from D

Thank you.

Hi
in J2 enter
=IF($A$2=G2,D2,"")
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

"Avram Berman" schrieb im Newsbeitrag
...
If A2 is found in Column G then insert the value of D2 into J2

e.g.,

If A2 is found at G50, then insert the value of D50 into J50

where
A = Address1 and G = Address 1 and D = Zip and J = Zip copied from D

Thank you.

Not that simple :-)

The value in in Column A2 has to be searched for a match in Column G
Once a match was found, e.g, A2 matched with G50, then the value in
D50 would be copied to J50

This process would repeat it self

A3 would be searched and matched to a value in Column G and so on.




Not that simple :-)

Hi
in J2 enter
=IF($A$2=G2,D2,"")
and copy down

If A2 is found in Column G then insert the value of D2 into J2

e.g.,

If A2 is found at G50, then insert the value of D50 into J50

where
A = Address1 and G = Address 1 and D = Zip and J = Zip copied from D

Hi
if I understood you correctly you need VBA to loop through your A2:An
range and change column J accordingly. ut of course you could try the
following in J2:
=IF(COUNTIF($A$2:$A$10,G2),D2,"")
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany

"Avram Berman" schrieb im
Newsbeitrag ...
Not that simple :-)

The value in in Column A2 has to be searched for a match in Column G
Once a match was found, e.g, A2 matched with G50, then the value in
D50 would be copied to J50

This process would repeat it self

A3 would be searched and matched to a value in Column G and so on.




Not that simple :-)

Hi
in J2 enter
=IF($A$2=G2,D2,"")
and copy down

If A2 is found in Column G then insert the value of D2 into J2

e.g.,

If A2 is found at G50, then insert the value of D50 into J50

where
A = Address1 and G = Address 1 and D = Zip and J = Zip copied from D

More like this:

=IF(ISNA(VLOOKUP(A2,G:G,4,FALSE)),"No","Yes")

If for example A2 was found at G50, the I want the value
of D50 to be written at J2.





On Fri, 19 Nov 2004 22:41:59 +0100, "Frank Kabel"
wrote:

Hi
if I understood you correctly you need VBA to loop through your A2:An
range and change column J accordingly. ut of course you could try the
following in J2:
=IF(COUNTIF($A$2:$A$10,G2),D2,"")
and copy this down

Hi
you have to decide:
1. Option: "A2 matched with G50, then the value in D50 would be copied
to J50"
2. Option: "A2 was found at G50, the I want the value of D50 to be
written at J2"

So my previous formula would work for option 2. For option one use in
J2:
=IF(COUNTIF($G$1:$G$100,A2),INDEX($J$1:$J$100,MATC H(A2,$G$1:$G$100,0)),
"")

--
Regards
Frank Kabel
Frankfurt, Germany

"Avram Berman" schrieb im
Newsbeitrag ...
More like this:

=IF(ISNA(VLOOKUP(A2,G:G,4,FALSE)),"No","Yes")

If for example A2 was found at G50, the I want the value
of D50 to be written at J2.





On Fri, 19 Nov 2004 22:41:59 +0100, "Frank Kabel"
wrote:

Hi
if I understood you correctly you need VBA to loop through your
A2:An
range and change column J accordingly. ut of course you could try
the
following in J2:
=IF(COUNTIF($A$2:$A$10,G2),D2,"")
and copy this down

Hi
should be of course vice-versa: First formula - for option 1
new formula - for option 2

--
Regards
Frank Kabel
Frankfurt, Germany

"Frank Kabel" schrieb im Newsbeitrag
...
Hi
you have to decide:
1. Option: "A2 matched with G50, then the value in D50 would be
copied
to J50"
2. Option: "A2 was found at G50, the I want the value of D50 to be
written at J2"

So my previous formula would work for option 2. For option one use in
J2:

=IF(COUNTIF($G$1:$G$100,A2),INDEX($J$1:$J$100,MATC H(A2,$G$1:$G$100,0)),
"")

--
Regards
Frank Kabel
Frankfurt, Germany

"Avram Berman" schrieb im
Newsbeitrag ...
More like this:

=IF(ISNA(VLOOKUP(A2,G:G,4,FALSE)),"No","Yes")

If for example A2 was found at G50, the I want the value
of D50 to be written at J2.





On Fri, 19 Nov 2004 22:41:59 +0100, "Frank Kabel"
wrote:

Hi
if I understood you correctly you need VBA to loop through your
A2:An
range and change column J accordingly. ut of course you could try
the
following in J2:
=IF(COUNTIF($A$2:$A$10,G2),D2,"")
and copy this down

I made a boo boo, sorry - this is what I wanted, if you could
tweak this formula:

=IF(COUNTIF($A$2:$A$14079,G2),D2,"")

to follow this logic it would be appreciated:

if a2 matches g50 the ni need to write the results of d2 at J50
and so on.



On Fri, 19 Nov 2004 23:00:48 +0100, "Frank Kabel"
wrote:

Hi
should be of course vice-versa: First formula - for option 1
new formula - for option 2

I made a boo boo, sorry - this is what I wanted, if you could
tweak this formula:

=IF(COUNTIF($A$2:$A$14079,G2),D2,"")

to follow this logic it would be appreciated:

if a2 matches g50 the i need to write the results of d2 at J50
and so on.



On Fri, 19 Nov 2004 23:00:48 +0100, "Frank Kabel"
wrote:

Hi
should be of course vice-versa: First formula - for option 1
new formula - for option 2

Hi
but what does not work with this formula if you copy it in all rows of
column G. You really have to explain what you mean with 'and so on'

--
Regards
Frank Kabel
Frankfurt, Germany

"Avram Berman" schrieb im
Newsbeitrag ...
I made a boo boo, sorry - this is what I wanted, if you could
tweak this formula:

=IF(COUNTIF($A$2:$A$14079,G2),D2,"")

to follow this logic it would be appreciated:

if a2 matches g50 the i need to write the results of d2 at J50
and so on.



On Fri, 19 Nov 2004 23:00:48 +0100, "Frank Kabel"
wrote:

Hi
should be of course vice-versa: First formula - for option 1
new formula - for option 2