Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Simple Function Help ~ Please
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing a Function | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Simple, Monday morning brain function | Excel Worksheet Functions | |||
Simple, Monday morning brain function | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |