Match data in sheet 1 and sheet 2 and import

[chiller]

Hi guys I have data as below

I have data as below which is sheet 1 , i would like to import sheet 2 and sheet 3 and populate cells year 2018 year 2019 in sheet 1,
unfortunately the values in column 1 which is supposed to be unique is corrupt so we only have address name and postcode to match off. some addresses have more than 1 member.
thanks.


ultimately the aim is to print of the sheet and chase non paid members, so may be a new sheet cab be created highlighting all debtors only showing the year they owe (reason being some have paid year 2020 and not paid 2019 and 2018)

this is for a charity , and i have been given the task, to establish all non payers and amount outstanding for each year and number of members not paid.

thankyou in advance


sheet 1

mr excell data .xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	No	MR/MRS	MEMBER NAME			ADDRESS	Post Code	Phone	year 2018	year 2019	year 2020
2	1	Mr	joe	bloggs	64	chorley road	BL1 5xw	123456789			80.00
3	2	Mr	prince	charles	8	Aldbury Terrace	BL1 3HX	7499399657
Sheet1

sheet 2

mr excell data .xlsm
	A	B	C	D	E	F	G	H	I
1	No	MR/MRS	MEMBER NAME		House No	ADDRESS	Post Code	Phone	Year 2019
2	1	Mr	joe	bloggs	64	chorley road	BL1 5HW	123456789	80
3	2	Mr	prince	charles	8	Aldbury Terrace	BL1 3HX	7499399657	80
Sheet2

sheet 3

mr excell data .xlsm
	A	B	C	D	E	F	G	H	I
1	No	MR/MRS	MEMBER NAME		House No	ADDRESS	Post Code	Phone	Year 2018
2	1	Mr	joe	bloggs	64	chorley road	BL1 5HW	123456789	80
3	2	Mr	prince	charles	8	Aldbury Terrace	BL1 3HX	7499399657	80
Sheet3

 

[mart37]

You can try SUMIFS

 

[chiller]

You can try SUMIFS

Complete novice to excell.
Can you guide.where would I enter formulae and what.

 

[mart37]

I2: SUMIFS(SHEET3!I:I,SHEET3!B:B;B2;SHEET3!C:C;C2;SHEET3!D:D;D2,..........)
With SHEET3!B:B;B2 can you test of MR/MRS is the same.
With SHEET3!C:C;C2 can you test of MEMBERNAME is the same.
For every match you add a column to the formula.

 

[chiller]

Is there any who can code A macro so this can be done quickly.