Matching

[aliabdullah20]

Please see the attached spread sheet. in the rows highlighted in yellow. I want to get the data from each year but only adding rows associated with "a" and "d". Normally I would do a vlookup but there are too many thing to match/index.

[TMS]

Please Login or Register  to view this content.

and copy across


Regards, TMS

[aliabdullah20]

Thanks. I also want to argument that will match the years. The destination of the formula might be on a different tab. Also the dates might move around, so its critical that I get the dates to match.

[Pepe Le Mokko]

Any other requirements before we continue?

[aliabdullah20]

No, Please continue. thanks

[TMS]

Ditto what Pepe said.

I want to get the data from each year but only adding rows associated with "a" and "d"

Match the years to what? The column headers are the years and you're example is adding columns.

The question, as asked, is answered = solved. Don't try to move the goalposts and expect us to run with you.

Suggest you mark this thread as solved and start a new thread with the new question, in full, with a sample workbook that reflects what you want to achieve. You may get new eyes and new input.

[newdoverman]

Try this:

Please Login or Register  to view this content.

	D	E	F	G	H	I	J	K	L	M
3		2015	2016	2017	2018	2019	2020	2021	2022	2023
4	A	1	123	195	165	157	140	154	110	171
5	b	2	168	151	128	141	160	172	138	109
6	c	2	187	149	131	137	186	102	186	135
7	d	3	154	115	100	104	191	100	112	162
8
9
10
11		2015	2018	2017	2016	2019	2020	2021	2022	2023
12	Total "a' and "d"	4	265	310	277	261	331	254	222	333