filter data or any other option - don't want to copy formula in all cells

[Vishaal]

Hi, we have the data in sheet1 and sheet2 and using index and match formula, its working fine

but we don't want to drag and drop formula from C2:C4 and again we have used formula in D2:D4, there is any formula from which we can get desired result so that don't do drop down

SHEET1

1250
2456
8765

SHEET2

1250	test 1	jabs 1	budd 1
7653	test 3	jabs 3	budd 3
1220	test 4	jabs 4	budd 4
6543	test 5	jabs 5	budd 5
2456	test 6	jabs 6	budd 6
9875	test 7	jabs 7	budd 7
6542	test 8	jabs 8	budd 8
8765	test 9	jabs 9	budd 9

Result Sheet

1250	test 1	budd 1
2456	test 6	budd 6
8765	test 9	budd 9

 

[Fluff]

With your version of Excel you have to drag the formula down. Spill ranges only exist in 2021 & 365

 

[Vishaal]

Okay, kindly provide how can we do

We will upgrade to 2021

 

[Fluff]

Impossible to help as you have given virtually no information.