Match data from another sheet (multiple criteria)

[Goddess]

Hi,

I have 3 sheets, "Data", "General Info" & "Analysis". General Info tab will have the list of companies and the country of origin. Data will be the factors that I need to apply to my analysis. Analysis tab is where all my calculations will be done.

In Analysis tab, cell C13:E13 & C15:E15 need to refer back to the number that is stated in the Data tab, based on the country listed in the General Info tab. The result I need is in the yellow cells (in Analysis) - Cell D13:E13. I tried applying my formula in Cell C13, but it didn't work. Can anyone advise where I went wrong?

Thanks!

Data

Sample1.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1				Spain	Italy	UK
2	Option A	KG	Apple	5	2	2
3
4			Orange	4	3	3
5
6			Grape	3	2	2
7
8		Liter	Strawberry	8	2	2
9
10		PCs	Banana	9	2	2
11
12			Pear	10	3	3
13
14			Cherry	0	0	0
15
16		Box	Papaya	11	12	13
17
18			Melon	0	NA	0
19
20	Option B	KG	Apple	33	33	33
21
22			Orange	36	36	36
23
24			Grape	26	26	26
25
26			Strawberry	34	34	34
27
28			Banana	46	46	46
29
30			Pear	45	45	45
31
32		PCs	Cherry	4	4	4
33
34			Papaya	4	4	0
35
36
Data

General Info

Sample1.xlsx
	B	C	D	E	F	G	H	I
1				Name of Entity	Division/Segment	City	Country
2		Details of Entity:		Company A			Spain
3				Company B			Italy
4				Company C			UK
5
6
7
8
9
General Info

Analysis

Sample1.xlsx
	A	B	C	D	E	F
1
2		Entity	Company A	Company B	Company C
3	SCOPE 1
4	Non-Renewable
5	1	Apple
6		Reference
7		Site 1	1	8	2	11
8		Site 2	5		5	10
9		Site 3		2		2
10		Site 4				0
11		Site 5				0
12		Total	6	10	7	23
13		Option B - Unit	0	33	33
14		Total	0	327.82	229.474	557.294
15		Option A - Unit		2	2
16		Total	#VALUE!	22.86183898	16.00328729	#VALUE!
17
18
Analysis

Cell Formulas
Range	Formula
C2	C2	='General Info'!$E$2
D2	D2	='General Info'!$E$3
E2	E2	='General Info'!$E$4
B5	B5	=Data!C2
F16,F14,F7:F12	F7	=SUM(C7:E7)
C12:E12	C12	=SUM(C7:C11)
C13	C13	=IFERROR(INDEX(Data!$D$20:$K$35,MATCH(INDEX('General Info'!$H$2:$H$7,MATCH(Analysis!C$2,'General Info'!$E$2:$E$7,0)),Data!1:1,0),MATCH(Analysis!$B$5,Data!C20:C35,0)),"")
D13:E13	D13	=Data!E20
C14:E14	C14	=C12*C13
C15	C15	=IFERROR(INDEX(Data!#REF!,MATCH(INDEX('General Info'!$H$2:$H$7,MATCH(Analysis!C$2,'General Info'!$E$2:$E$7,0)),Data!#REF!,0),MATCH(Analysis!$B$5,Data!#REF!,0)),"")
D15:E15	D15	=Data!E2
C16:E16	C16	=C12*C15

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B11	Expression	=ISNUMBER(SEARCH("Materiality",FORMULATEXT(B11)))	text	NO
B9:B10	Expression	=ISNUMBER(SEARCH("Materiality",FORMULATEXT(B9)))	text	NO
B8,B12	Expression	=ISNUMBER(SEARCH("Materiality",FORMULATEXT(B8)))	text	NO
B7	Expression	=ISNUMBER(SEARCH("Materiality",FORMULATEXT(B7)))	text	NO
B13:B17	Expression	=ISNUMBER(SEARCH("Materiality",FORMULATEXT(B13)))	text	NO
C2:E2	Expression	=ISNUMBER(SEARCH("Materiality",FORMULATEXT(C2)))	text	NO
B2	Expression	=ISNUMBER(SEARCH("Materiality",FORMULATEXT(B2)))	text	NO
C1	Expression	=ISNUMBER(SEARCH("Materiality",FORMULATEXT(C1)))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B2:F2	Any value