i need that column c in table 2 will fill automatic

[mgm90210M]

a1	b1	c1	d1	e1
	reading glasses <tbody> </tbody>		reading glasses <tbody> </tbody>
	reading glasses <tbody> </tbody>		bifocal reading glasses <tbody> </tbody>
	eye glass <tbody> </tbody> <tbody> </tbody>		folding reading glasses <tbody> </tbody> <tbody> </tbody>
	eye glass <tbody> </tbody>		foster grant reading glasses <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

a7939	b7939	c7939	d7939	e7939
		eye glass	folding reading glasses
		reading glasses	reading glasses
		eye glass	foster grant reading glasses
		reading glasses	bifocal reading glasses

<tbody>
</tbody>

please

i need that column c in table 2 will fill automatic
so i need function for column c in table 2


( to take the word in column d in table 2
and look the word in table 1 in column d
and her much in column b in table 1
and write it on table 2 in column c )

a5410	b5410	c5410	d5410	e5410
				bifocal readibbng glhgdcasses <tbody> </tbody>
				bifocal reading glasses <tbody> </tbody>
				reading glassggggges online <tbody> </tbody>
				reading glasses online <tbody> </tbody>

<tbody>
</tbody>

a5418	b5418	c5418	d5418	e5418	f5418	g5418
			bifocal reading glasses <tbody> </tbody>		Leader Number <tbody> </tbody>
			reading glasses online		Leader Number <tbody> </tbody>
			folding reading glasses <tbody> </tbody> <tbody> </tbody>
			reading glassggggges online <tbody> </tbody>		Leader Number <tbody> </tbody>
			designer reading glasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>
			bifocal readibbng glhgdcasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>		Leader Number <tbody> </tbody>

<tbody>
</tbody>

please
i need function that take the word in table 2 that have the "Leader Number" in there row in column f
and put those word in column e in the first table
like i show

a5410	b5410	c5410	d5410	e5410
				bifocal readibbng glhgdcasses <tbody> </tbody>
				bifocal reading glasses <tbody> </tbody>
				reading glassggggges online <tbody> </tbody>
				reading glasses online <tbody> </tbody>

<tbody>
</tbody>

a5418	b5418	c5418	d5418	e5418	f5418	g5418
			bifocal reading glasses <tbody> </tbody>		Leader Number <tbody> </tbody>
			reading glasses online		Leader Number <tbody> </tbody>
			folding reading glasses <tbody> </tbody> <tbody> </tbody>
			reading glassggggges online <tbody> </tbody>		Leader Number <tbody> </tbody>
			designer reading glasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>
			bifocal readibbng glhgdcasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>		Leader Number <tbody> </tbody>

<tbody>
</tbody>

please
i need function that take the word in table 2 that have the "Leader Number" in there row in column f
and put those word in column e in the first table
like i show

a1	b1	c1	d1	e1
	reading glasses <tbody> </tbody>		reading glasses <tbody> </tbody>
	reading glasses <tbody> </tbody>		bifocal reading glasses <tbody> </tbody>
	eye glass <tbody> </tbody> <tbody> </tbody>		folding reading glasses <tbody> </tbody> <tbody> </tbody>
	eye glass <tbody> </tbody>		foster grant reading glasses <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

a7939	b7939	c7939	d7939	e7939
		eye glass	folding reading glasses
		reading glasses	reading glasses
		eye glass	foster grant reading glasses
		reading glasses	bifocal reading glasses

<tbody>
</tbody>

please

i need that column c in table 2 will fill automatic
so i need function for column c in table 2


( to take the word in column d in table 2
and look the word in table 1 in column d
and her much in column b in table 1
and write it on table 2 in column c )

a5410	b5410	c5410	d5410	e5410
				bifocal readibbng glhgdcasses <tbody> </tbody>
				bifocal reading glasses <tbody> </tbody>
				reading glassggggges online <tbody> </tbody>
				reading glasses online <tbody> </tbody>

<tbody>
</tbody>

a5418	b5418	c5418	d5418	e5418	f5418	g5418
			bifocal reading glasses <tbody> </tbody>		Leader Number <tbody> </tbody>
			reading glasses online		Leader Number <tbody> </tbody>
			folding reading glasses <tbody> </tbody> <tbody> </tbody>
			reading glassggggges online <tbody> </tbody>		Leader Number <tbody> </tbody>
			designer reading glasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>
			bifocal readibbng glhgdcasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>		Leader Number <tbody> </tbody>

<tbody>
</tbody>

please
i need function that take the word in table 2 that have the "Leader Number" in there row in column f
and put those word in column e in the first table
like i show​

a5410	b5410	c5410	d5410	e5410
				bifocal readibbng glhgdcasses <tbody> </tbody>
				bifocal reading glasses <tbody> </tbody>
				reading glassggggges online <tbody> </tbody>
				reading glasses online <tbody> </tbody>

<tbody>
</tbody>

a5418	b5418	c5418	d5418	e5418	f5418	g5418
			bifocal reading glasses <tbody> </tbody>		Leader Number <tbody> </tbody>
			reading glasses online		Leader Number <tbody> </tbody>
			folding reading glasses <tbody> </tbody> <tbody> </tbody>
			reading glassggggges online <tbody> </tbody>		Leader Number <tbody> </tbody>
			designer reading glasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>
			bifocal readibbng glhgdcasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>		Leader Number <tbody> </tbody>

<tbody>
</tbody>

please
i need function that take the word in table 2 that have the "Leader Number" in there row in column f
and put those word in column e in the first table
like i show

a5410	b5410	c5410	d5410	e5410
				bifocal readibbng glhgdcasses <tbody> </tbody>
				bifocal reading glasses <tbody> </tbody>
				reading glassggggges online <tbody> </tbody>
				reading glasses online <tbody> </tbody>

<tbody>
</tbody>

a5418	b5418	c5418	d5418	e5418	f5418	g5418
			bifocal reading glasses <tbody> </tbody>		Leader Number <tbody> </tbody>
			reading glasses online		Leader Number <tbody> </tbody>
			folding reading glasses <tbody> </tbody> <tbody> </tbody>
			reading glassggggges online <tbody> </tbody>		Leader Number <tbody> </tbody>
			designer reading glasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>
			bifocal readibbng glhgdcasses <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>		Leader Number <tbody> </tbody>

<tbody>
</tbody>

please
i need function that take the word in table 2 that have the "Leader Number" in there row in column f
and put those word in column e in the first table
like i show

 

[Michael M]

Re: column e in the first table

PLease don't duplicate post, stick to the original thread.