Vlookup Technique Help

[Excel777]

Hey,
Plz Need Help In This Lookup Technique

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2	Formula	LookUp Values	Table Array		Data	Results		Table1		Table2		Table3
3	#N/A	A1:A9	Table2		A1	100		A1	1	A1	100	A1	1000
4					A2	101		A2	2	A2	101	A2	1001
5					A3	102		A3	3	A3	102	A3	1002
6					A4	103		A4	4	A4	103	A4	1003
7					A5	104		A5	5	A5	104	A5	1004
8					A6	105		A6	6	A6	105	A6	1005
9					A7	106		A7	7	A7	106	A7	1006
10					A8	107		A8	8	A8	107	A8	1007
11					A9	108		A9	9	A9	108	A9	1008
12								A10	10	A10	109	A10	1009
13								A11	11	A11	110	A11	1010
14								A12	12	A12	111	A12	1011
15								A13	13	A13	112	A13	1012
16								A14	14	A14	113	A14	1013
17								A15	15	A15	114	A15	1014
Sheet2

My look Up Formula Is In Cell A3
In Cell B3 The "Lookup Values" It's The Range From "A1:A9"
In Cell C3 The Data List Including Table 1,2,3 "Table Array"
My Results Of Shoul Be In Cells F3:F11

How Can I Apply This

Thanks In Advance

 

[VoG]

With the values to lookup stored in the named range Names try

Sub lkup()
Dim c As Range, i As Integer
i = 2
Range("E3:F1000").ClearContents
For Each c In Range("Names")
    If c.Value <> "" Then
        i = i + 1
        Range("E" & i).Value = c.Value
        Range("F" & i).Formula = "=VLOOKUP(""" & Range("E" & i).Value & """," & Range("C3").Value & ",2,false)"
    End If
Next c
End Sub

 

[Excel777]

Thank,
When I Run The Macro It Clear The Values In Column "E" The Fixed Names And Don't Give Me Rsults

 

[VoG]

I used the named range Names as B3:B10. Then

Before:

<b>Sheet7</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">F</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">G</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">H</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">I</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">J</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">K</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">L</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">M</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td >LookUp</td><td >Array</td><td > </td><td >Data</td><td >Results</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td >A1</td><td >Table2</td><td > </td><td > </td><td > </td><td > </td><td >A1</td><td style="text-align:right; ">78</td><td >A1</td><td style="text-align:right; ">58</td><td >A1</td><td style="text-align:right; ">79</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td >A2</td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A2</td><td style="text-align:right; ">33</td><td >A2</td><td style="text-align:right; ">91</td><td >A2</td><td style="text-align:right; ">89</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td >A3</td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A3</td><td style="text-align:right; ">49</td><td >A3</td><td style="text-align:right; ">58</td><td >A3</td><td style="text-align:right; ">69</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td >A4</td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A4</td><td style="text-align:right; ">46</td><td >A4</td><td style="text-align:right; ">44</td><td >A4</td><td style="text-align:right; ">46</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td >George</td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A5</td><td style="text-align:right; ">44</td><td >A5</td><td style="text-align:right; ">95</td><td >A5</td><td style="text-align:right; ">43</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >8</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A6</td><td style="text-align:right; ">29</td><td >A6</td><td style="text-align:right; ">28</td><td >A6</td><td style="text-align:right; ">4</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >9</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A7</td><td style="text-align:right; ">46</td><td >A7</td><td style="text-align:right; ">55</td><td >A7</td><td style="text-align:right; ">49</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >10</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >George</td><td style="text-align:right; ">81</td><td >George</td><td style="text-align:right; ">88</td><td >A8</td><td style="text-align:right; ">40</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >11</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A9</td><td style="text-align:right; ">39</td><td >A9</td><td style="text-align:right; ">95</td><td >A9</td><td style="text-align:right; ">69</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >12</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A10</td><td style="text-align:right; ">86</td><td >A10</td><td style="text-align:right; ">21</td><td >A10</td><td style="text-align:right; ">50</td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4


After

<b>Sheet7</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">F</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">G</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">H</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">I</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">J</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">K</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">L</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">M</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td >LookUp</td><td >Array</td><td > </td><td >Data</td><td >Results</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td >A1</td><td >Table2</td><td > </td><td >A1</td><td style="text-align:right; ">58</td><td > </td><td >A1</td><td style="text-align:right; ">78</td><td >A1</td><td style="text-align:right; ">58</td><td >A1</td><td style="text-align:right; ">79</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td >A2</td><td > </td><td > </td><td >A2</td><td style="text-align:right; ">91</td><td > </td><td >A2</td><td style="text-align:right; ">33</td><td >A2</td><td style="text-align:right; ">91</td><td >A2</td><td style="text-align:right; ">89</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td >A3</td><td > </td><td > </td><td >A3</td><td style="text-align:right; ">58</td><td > </td><td >A3</td><td style="text-align:right; ">49</td><td >A3</td><td style="text-align:right; ">58</td><td >A3</td><td style="text-align:right; ">69</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td >A4</td><td > </td><td > </td><td >A4</td><td style="text-align:right; ">44</td><td > </td><td >A4</td><td style="text-align:right; ">46</td><td >A4</td><td style="text-align:right; ">44</td><td >A4</td><td style="text-align:right; ">46</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td >George</td><td > </td><td > </td><td >George</td><td style="text-align:right; ">88</td><td > </td><td >A5</td><td style="text-align:right; ">44</td><td >A5</td><td style="text-align:right; ">95</td><td >A5</td><td style="text-align:right; ">43</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >8</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A6</td><td style="text-align:right; ">29</td><td >A6</td><td style="text-align:right; ">28</td><td >A6</td><td style="text-align:right; ">4</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >9</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A7</td><td style="text-align:right; ">46</td><td >A7</td><td style="text-align:right; ">55</td><td >A7</td><td style="text-align:right; ">49</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >10</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >George</td><td style="text-align:right; ">81</td><td >George</td><td style="text-align:right; ">88</td><td >A8</td><td style="text-align:right; ">40</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >11</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A9</td><td style="text-align:right; ">39</td><td >A9</td><td style="text-align:right; ">95</td><td >A9</td><td style="text-align:right; ">69</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >12</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A10</td><td style="text-align:right; ">86</td><td >A10</td><td style="text-align:right; ">21</td><td >A10</td><td style="text-align:right; ">50</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >F3</td><td >=VLOOKUP("A1",Table2,2,FALSE)</td></tr><tr><td >F4</td><td >=VLOOKUP("A2",Table2,2,FALSE)</td></tr><tr><td >F5</td><td >=VLOOKUP("A3",Table2,2,FALSE)</td></tr><tr><td >F6</td><td >=VLOOKUP("A4",Table2,2,FALSE)</td></tr><tr><td >F7</td><td >=VLOOKUP("George",Table2,2,FALSE)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[Excel777]

Yeah
Suppose Lookup Values Is B3
Auppose Array Is Table 2

So When I Write In Cell "B3" The Look Up Values "E2:E7"

The VBA Look Abt The Names In The Cells From "E2:E7" Which Is

Column E
Data
<table style="border-collapse: collapse; width: 48pt;" border="0" cellpadding="0" cellspacing="0" width="64"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" height="20" width="64">A1</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A2</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A3</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A4</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">George</td> </tr> </tbody></table>
I Wish My Point Clear Now

 

[VoG]

No it isn't clear.

If you already have your values to lookup in column E, why do you need a macro?

 

[Excel777]

I Need The Macro Coz
In Column E
It's From E2:E14000 In My Sheet And I Sometimes Search
From
E2:E5000 In Table 3
From E5001:E15000In Table 2

And so On According To The Nature Of The Work

So It Will Be So Difficult For me To Chnage The Lookup Values And LookUp Array constantly

So I Need The Macro

Back To Our Point

B3 = E2:E7 In Ur Last table And This E2:E7 Is The Names From A1:Gorge In Your Last Table Under Column E

C3 THe Tables No Change

So The Look Up Formula Which I Need To Put In A Macro IS
Vlookup(B3,C3,2,0)

Thanks In Advance

 

[VoG]

Perhaps this is what you mean

Sub lkup()
Dim c As Range
Range("F3:F1000").ClearContents
For Each c In Range(Range("B3").Value)
    If c.Value <> "" Then
        c.Offset(, 1).Formula = "=VLOOKUP(""" & c.Value & """," & Range("C3").Value & ",2,false)"
    End If
Next c
End Sub

<b>Sheet7</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">B</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">C</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">D</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">E</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">F</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">G</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">H</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">I</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">J</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">K</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">L</td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">M</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td >LookUp</td><td >Array</td><td > </td><td >Data</td><td >Results</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td >E4:E7</td><td >Table2</td><td > </td><td >A1</td><td > </td><td > </td><td >A1</td><td style="text-align:right; ">78</td><td >A1</td><td style="text-align:right; ">58</td><td >A1</td><td style="text-align:right; ">79</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td > </td><td > </td><td > </td><td >A2</td><td style="text-align:right; ">91</td><td > </td><td >A2</td><td style="text-align:right; ">33</td><td >A2</td><td style="text-align:right; ">91</td><td >A2</td><td style="text-align:right; ">89</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td > </td><td > </td><td > </td><td >A3</td><td style="text-align:right; ">58</td><td > </td><td >A3</td><td style="text-align:right; ">49</td><td >A3</td><td style="text-align:right; ">58</td><td >A3</td><td style="text-align:right; ">69</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td > </td><td > </td><td > </td><td >A4</td><td style="text-align:right; ">44</td><td > </td><td >A4</td><td style="text-align:right; ">46</td><td >A4</td><td style="text-align:right; ">44</td><td >A4</td><td style="text-align:right; ">46</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td > </td><td > </td><td > </td><td >George</td><td style="text-align:right; ">88</td><td > </td><td >A5</td><td style="text-align:right; ">44</td><td >A5</td><td style="text-align:right; ">95</td><td >A5</td><td style="text-align:right; ">43</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >8</td><td > </td><td > </td><td > </td><td >Fred</td><td > </td><td > </td><td >A6</td><td style="text-align:right; ">29</td><td >A6</td><td style="text-align:right; ">28</td><td >A6</td><td style="text-align:right; ">4</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >9</td><td > </td><td > </td><td > </td><td >Ian</td><td > </td><td > </td><td >A7</td><td style="text-align:right; ">46</td><td >A7</td><td style="text-align:right; ">55</td><td >A7</td><td style="text-align:right; ">49</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >10</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >George</td><td style="text-align:right; ">81</td><td >George</td><td style="text-align:right; ">88</td><td >A8</td><td style="text-align:right; ">40</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >11</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A9</td><td style="text-align:right; ">39</td><td >A9</td><td style="text-align:right; ">95</td><td >A9</td><td style="text-align:right; ">69</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >12</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >A10</td><td style="text-align:right; ">86</td><td >A10</td><td style="text-align:right; ">21</td><td >A10</td><td style="text-align:right; ">50</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >F4</td><td >=VLOOKUP("A2",Table2,2,FALSE)</td></tr><tr><td >F5</td><td >=VLOOKUP("A3",Table2,2,FALSE)</td></tr><tr><td >F6</td><td >=VLOOKUP("A4",Table2,2,FALSE)</td></tr><tr><td >F7</td><td >=VLOOKUP("George",Table2,2,FALSE)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[Excel777]

Exactly This Is What I Want, Many Thanks Peter For All Your Replies

Regards,
Excelllearner

 

[Excel777]

Plz If The Data In Column "E" Is Numbers Not Text
What I should Modify In The Code

Coz I Get Results #N/A

Thanks

 

[Excel777]

And These Numbers Which In Column "E" As A Result Of Formula Process

What Should Be The Code