Simple Function Help ~ Please

[Avram Berman]

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.

 

[Frank Kabel]

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

 

[Avram Berman]

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

 

[Frank Kabel]

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

 

[Avram Berman]

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.

 

[Frank Kabel]

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,MATCH(A2,$G$1:$G$100,0)),
"")

 

[Frank Kabel]

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

 

[Avram Berman]

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.

 

[Avram Berman]

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.

 

[Frank Kabel]

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'