show in the sample above

mgm90210M

Board Regular
Joined
Feb 14, 2013
Messages
92
ABCDEFG
1Group 11reading wqa
0.013208861227

<tbody>
</tbody>

Leader Number

<tbody>
</tbody>


<tbody>
</tbody>

2Group 12rekljading wqa
0.013207881227

<tbody>
</tbody>

3Group 13regfading wqa
0.013254081227

<tbody>
</tbody>

4Group 24reading hbhhgfb
0.013209081227

<tbody>
</tbody>

Leader Number

<tbody>
</tbody>

5Group 25reading hbufshb
0.013542081227

<tbody>
</tbody>

6Group 26rehjgading hbhb
0.013432081227

<tbody>
</tbody>

Leader Number

<tbody>
</tbody>

7Group 37readhfding wkl
0.013208671227

<tbody>
</tbody>

8Group 38reajiuding wkl
0.013265081227

<tbody>
</tbody>

9Group 39reghjading wkl
0.013208781227

<tbody>
</tbody>

Leader Number

<tbody>
</tbody>

10Group 410reanhjding wkl
0.013208431227

<tbody>
</tbody>

11Group 411regdsading wkl
0.013208781227

<tbody>
</tbody>

12Group 412rekoiading wkl
0.013205681227

<tbody>
</tbody>

Leader Number

<tbody>
</tbody>

13Group 513readhjning wkl
0.013207681227

<tbody>
</tbody>

14Group 514readvcding wkl
0.053132081227

<tbody>
</tbody>

Leader Number

<tbody>
</tbody>

15Group 515readthding qq
0.013892081227

<tbody>
</tbody>

16

<tbody>
</tbody>





a18b18c18d18e18f18
reading wqa
reading hbhhgfb
rehjgading hbhb
reghjading wkl
rekoiading wkl
readvcding wkl

<tbody>
</tbody>





please.
i need that every row in first table that have the "Leader Number" in the colom f of her
will copy the word in column d in the first table to second table to column e (in the second table)
like i show in the sample above :
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
you can use vlookup if u put column g and insert into column d

mean u copy col g and insert into col d

=vlookup("Leader Number",D:E,2,0)
 
Upvote 0

Forum statistics

Threads
1,203,203
Messages
6,054,117
Members
444,703
Latest member
pinkyar23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top