Notes for question 2 here
https://excelfox.com/forum/showthrea...ll=1#post13379
https://excelfox.com/forum/showthrea...ll=1#post13387


Before is as here ,
https://excelfox.com/forum/showthrea...ll=1#post13382
, but ignore Sheet2 - no row is to be copied

If column J has data in actual file.xlsx then match column B of actual file.xlsx

_____ Workbook: Actual File.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
1
 Exchange Symbol Series/Expiry Open High Low Prev Close LTP
2
 NSE ASHOKLEY EQ
65
65.35
60.55
63.3
63.3
1
3
 NSE BANKBARODA EQ
62.1
62.95
56.15
56.65
56.65
1
4
 NSE BEL EQ
66.15
66.75
62.4
65.65
65.65
1
5
 NSE EQUITAS EQ
82
82.05
71
73.05
73.05
1
6
 NSE FEDERALBNK EQ
68
68.45
62.45
63.1
63.1
1
7
 NSE GAIL EQ
85
88.8
79.1
79.95
79.95
1
8
 NSE IDFCFIRSTB EQ
32.1
32.35
27.2
27.55
27.55
9
 NSE IOC EQ
93
93.65
87.25
87.9
87.9
10
 NSE L&TFH EQ
90
91.55
80.5
81.65
81.65
11
Worksheet: Sheet1 (2)

_.................If column J has data in actual file.xlsx then match column B of actual file.xlsx with column A of sheet 1 of 2.xlsx

_____ Workbook: 2 (2).xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
1
 Stock Name data data data data data data data data data data data data data data
2
 ACC
100
108
120
128
134
151
6534
30
90
97
103
3
 ADANIENT
101
109
121
127
135
122
782
40
92
98
4
 ADANIPORTS
102
110
122
16
137
177
10
50
93
99
104
5
 ASHOKLEY
1
2
3
4
5
16
137
177
10
50
93
99
104
6
 EQUITAS
10
50
93
99
5
102
110
122
9
10
11
7
 L&TFH
11
12
13
14
15
16
17
18
19
20
21
22
23
8
Worksheet: Sheet1

If column J has data in actual file.xlsx then match column B of actual file.xlsx with column A of sheet 1 of 2.xlsx and if it matches then double the value of that row of 2.xlsx

After

_____ Workbook: 2 (2).xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
1
 Stock Name data data data data data data data data data data data data data data
2
 ACC
100
108
120
128
134
151
6534
30
90
97
103
3
 ADANIENT
101
109
121
127
135
122
782
40
92
98
4
 ADANIPORTS
102
110
122
16
137
177
10
50
93
99
104
5
 ASHOKLEY
2
4
6
8
10
32
274
354
20
100
186
198
208
6
 EQUITAS
20
100
186
198
10
204
220
244
18
20
22
7
 L&TFH
22
24
26
28
30
32
34
36
38
40
42
44
46
8
Worksheet: Sheet2

Note: I think your supplied After is wrong! - L&TFH should not be considered from Actual File.xlsx, because J of that row is not 1