Some notes in support in answering this question: https://excelfox.com/forum/showthrea...ata-if-matches

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 copy the (only first row)entire row of data from sheet2 of 2.xlsx and paste it to sheet 1 of 2.xlsx in the row of the matched value in column A of sheet 1 of 2.xlsx
i have pasted the result in sheet3 of 2.xlsx but the result should be in sheet1(I have pasted the result in sheet3 only for understanding purpose)


Before:

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
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
_____ Workbook: 2 18May.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
1
 Stock Name
2
 ACC
3
 ADANIENT
4
 ADANIPORTS
5
 ASHOKLEY
6
 EQUITAS
7
 L&TFH
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 copy the (only first row)entire row of data from sheet2 of 2.xlsx and paste it to sheet 1 of 2.xlsx
_____ Workbook: 2 18May.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
1
1
2
3
4
5
6
7
8
9
10
Worksheet: Sheet2

_.......copy the (only first row)entire row of data from sheet2 of 2.xlsx and paste it to sheet 1 of 2.xlsx
i have pasted the result in sheet3 of 2.xlsx but the result should be in sheet1(I have pasted the result in sheet3 only for understanding purpose)

After:

_____ Workbook: 2 18May.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
1
 Stock Name 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
6
7
8
9
10
6
 EQUITAS
1
2
3
4
5
6
7
8
9
10
7
 AMBUJACEM
105
117
125
133
140
746
23
80
96
102
109
8
Worksheet: Sheet3