VLookup(?) Question

[Biddlecom]

Hello, I have 2 sheets in 1 workbook and I want to pull the weekly sales numbers from column B in sheet 1 and have it autofill under the correct item numbers in sheet 2. Is that possible?

 

[Sergius]

Hello! This should work.

пример (8).xlsx
	A	B
2	Item number	Weekly sales
3	114914	580
4	721083	174
5	327252	974
6	933421	64
7	539590	344
8	145759	111
9	751928	412
10	358097	150
11	630932	250
12	737101	333
13	111111	800
Sheet1

пример (8).xlsx
	A	B	C	D	E	F	G
3	A11	A12	A13	A14	A15	A16	A17
4	111111	111111	111111	114914	358097	721083	327252
5	800	800	800	580	150	174	974
6	A21	A22	A23	A24	A25	A26	A27
7	145759	721083	539590	933421	751928	630932	358097
8	111	174	344	64	412	250	150
9	A31	A32	A33	A34	A35	A36	A37
10	145759	737101	358097	721083	630932	358097	539590
11	111	333	150	174	250	150	344
Sheet2

Cell Formulas
Range	Formula
A5:G5	A5	=INDEX(Sheet1!$A$3:$B$13,MATCH(Sheet2!A$4,Sheet1!$A$3:$A$13,0),2)
A8:G8	A8	=INDEX(Sheet1!$A$3:$B$13,MATCH(Sheet2!A$7,Sheet1!$A$3:$A$13,0),2)
A11:G11	A11	=INDEX(Sheet1!$A$3:$B$13,MATCH(Sheet2!A$10,Sheet1!$A$3:$A$13,0),2)

 

[Biddlecom]

Hello! This should work.

пример (8).xlsx
	A	B
2	Item number	Weekly sales
3	114914	580
4	721083	174
5	327252	974
6	933421	64
7	539590	344
8	145759	111
9	751928	412
10	358097	150
11	630932	250
12	737101	333
13	111111	800
Sheet1

пример (8).xlsx
	A	B	C	D	E	F	G
3	A11	A12	A13	A14	A15	A16	A17
4	111111	111111	111111	114914	358097	721083	327252
5	800	800	800	580	150	174	974
6	A21	A22	A23	A24	A25	A26	A27
7	145759	721083	539590	933421	751928	630932	358097
8	111	174	344	64	412	250	150
9	A31	A32	A33	A34	A35	A36	A37
10	145759	737101	358097	721083	630932	358097	539590
11	111	333	150	174	250	150	344
Sheet2

Cell Formulas
Range	Formula
A5:G5	A5	=INDEX(Sheet1!$A$3:$B$13,MATCH(Sheet2!A$4,Sheet1!$A$3:$A$13,0),2)
A8:G8	A8	=INDEX(Sheet1!$A$3:$B$13,MATCH(Sheet2!A$7,Sheet1!$A$3:$A$13,0),2)
A11:G11	A11	=INDEX(Sheet1!$A$3:$B$13,MATCH(Sheet2!A$10,Sheet1!$A$3:$A$13,0),2)

Thank you. It worked perfect.