Newbie Question

[excelnewbie2023]

Hello!

I apologize in advance for what is probably a very simple question but I have done quite a bit of digging on Google and can't find my answer, perhaps I am phrasing it wrong.

I am trying to compare sales for two different periods. I have two different sheets, one for each period. Each sheet has "Column A" that includes the customer number. "Column C" contains the sales amount for that period for each customer. In this case, I am comparing January 2022 with January 2023. I want to paste the figures from 2022 into the blank "Column D" so I can see the sales for each period side by side but I need Excel to match the figures with the customer number.

Basically, if the customer number matches in Column A, insert the numbers into Column D.

Hopefully my question makes sense and you're able to help me!

THANK YOU in advance!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))

Change sheet name to suit

 

[excelnewbie2023]

I think we are very close, but it didn't seem to work to copy all of the lines. Here are the two sheets:

This is sheet January 2022:

demo.xlsx
	A	B	C
1	No.	Name	Amount of Sales ($)
2	1010017	demo	1,799.63
3	1018603	demo	392.00
4	1018622	demo	2,209.98
5	1018645	demo	48.00
6	1018652	demo	1,444.93
7	1018658	demo	410.59
8	1018666	demo	26.97
9	1018673	demo	996.56
10	1018722	demo	1,532.58
11	1018740	demo	743.79
12	1018784	demo	2,352.00
13	1018802	demo	227.36
14	1018803	demo	29.86
15	1018806	demo	89.00
January 2022

This is sheet January 2023, where I want to take the data from column C in "January 2022" and add it to Column D in "January 2023", but I need it to match the customer numbers in Column A because, for example, some of the customers didn't buy again in January 2023 and are missing from the January 2023 sheet.

demo.xlsx
	A	B	C	D
1	No.	Name	Amount of Sales ($)	2022 Sales
2	1010017	demo	1,117.82
3	1018603	demo	202.90
4	1018645	demo	258.68
5	1018652	demo	259.78
6	1018658	demo	373.37
7	1018722	demo	572.28
8	1018740	demo	2,283.59
9	1018759	demo	59.50
10	1018793	demo	117.08
11	1018803	demo	7.98
12	1018806	demo	182.54
13	1018845	demo	219.98
January 2023

 

[excelnewbie2023]

And again, THANK YOU so much for your help!

 

[Fluff]

In what way doesn't the formula work?

 

[excelnewbie2023]

I may be doing something wrong. If I paste that formula it keeps giving me the result from C2 on each row.

 

[Fluff]

Can you repost the 2023 sheet with the formula in place

 

[excelnewbie2023]

Here you go. I'm very ignorant when it comes to Excel, so please pardon if I'm making a very simple mistake.

demo.xlsx
	A	B	C	D
1	No.	Name	Amount of Sales ($)	2022 Sales
2	1010017	demo	1,117.82	1799.63
3	1018603	demo	202.90	1799.63
4	1018645	demo	258.68	1799.63
5	1018652	demo	259.78	1799.63
6	1018658	demo	373.37	1799.63
7	1018722	demo	572.28	1799.63
8	1018740	demo	2,283.59	1799.63
9	1018759	demo	59.50	1799.63
10	1018793	demo	117.08	1799.63
11	1018803	demo	7.98	1799.63
12	1018806	demo	182.54	1799.63
13	1018845	demo	219.98	1799.63
January 2023

Cell Formulas
Range	Formula
D2	D2	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D3	D3	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D4	D4	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D5	D5	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D6	D6	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D7	D7	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D8	D8	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D9	D9	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D10	D10	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D11	D11	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D12	D12	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))
D13	D13	=INDEX('January 2022'!$C$2:$C$1000,MATCH(A2,'January 2022'!$A$2:$A$1000,0))

 

[Fluff]

Ok, they all return the same value as you are matching A2 on every row. Just put the formula in D2 & then drag it down.

 

[excelnewbie2023]

Ok, they all return the same value as you are matching A2 on every row. Just put the formula in D2 & then drag it down.

That is what I was doing wrong. It is working perfect now. THANK YOU SO MUCH!! This will save me a lot of time in the future, very much appreciated.