HELP!

[hayden610]

I have a sheet (sheet 1) that I will be putting a 3 digit number in one tab that will calculate in 2 other cells
I want to run a macro that will read the row number and read the cell A, C, E and then go into the other sheet (sheet 2) and find those numbers that are in cell a and insert the dollar amounts from cell B,D,E from Sheet 1.

and if their is something in those cells that we will be adding the amounts to add them together

I have attached pictures of the sheets

sheet 1

Sheet 2

 

[KRice]

You can do this with a formula-based approach, if you are interested. What should happen if the first number cannot be found? The approach below searches for the Pick3 number and then returns all three values (base, +1, -1) associated with it...and if it is not found, a "not found" result is returned.

MrExcel20200915.xlsx
	A	B	C	D	E
1	Number	Name	Pick3	Pick3 +1	Pick3-1
2	14		$1.00	$2.00	$1.50
3	386		$2.00	$3.00	$2.50
4	27		$3.00	$5.00	$3.50
5	422		$4.00	$8.00	$4.50
6	44		$5.00	$13.00	$5.50
7	586		$6.00	$21.00	$6.50
8	101		$7.00	$34.00	$7.50
hayden610_sheet2

MrExcel20200915.xlsx
	A	B	C	D	E	F	G
1	3-digit number	Amt	OneAbove	Amt	OneBelow	Amt	Total
2	386	$2.00	387	$3.00	385	$2.50	$7.50
3	422	$4.00	423	$8.00	421	$4.50	$16.50
4	586	$6.00	587	$21.00	585	$6.50	$33.50
5	123	not found	124	not found	122	not found	$0.00
hayden610_sheet1

Cell Formulas
Range	Formula
B2:B5	B2	=IFERROR(INDEX(hayden610_sheet2!$C$2:$C$8,MATCH($A2,hayden610_sheet2!$A$2:$A$8,0)),"not found")
C2:C5	C2	=A2+1
D2:D5	D2	=IFERROR(INDEX(hayden610_sheet2!$D$2:$D$8,MATCH($A2,hayden610_sheet2!$A$2:$A$8,0)),"not found")
E2:E5	E2	=A2-1
F2:F5	F2	=IFERROR(INDEX(hayden610_sheet2!$E$2:$E$8,MATCH($A2,hayden610_sheet2!$A$2:$A$8,0)),"not found")
G2:G5	G2	=SUM(B2,D2,F2)