Nested match?

[Patrick Niedermeyer]

I'm trying to update historical data tables where each entry I need transferred will have to match two qualifiers: location and chemical. Each location has 9 different chemicals in the new data table. What function should I use to populate my historical table with the new results that will find both and fetch the appropriate concentration data?

Missouri_Example.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
8	Historical data table
9	location	date	Chemical										New Data, Date: 6
10			blue, (mg/L)	green, (mg/L)	red, (mg/L)	purple, (mg/L)	orange, (mg/L)	yellow, (mg/L)	grey, (mg/L)	white, (mg/L)	black, (mg/L)		Location	Chemical	Conc, (mg/L)
11	A	1	21	7	23	18	46	14	22	40	10		A	blue	1
12	A	2	17	26	8	12	28	20	4	12	38		A	green	2
13	A	3	3	34	23	13	36	39	32	19	23		A	red	3
14	A	4	28	3	17	23	31	9	19	49	46		A	purple	4
15	A	5	16	24	41	32	24	1	16	20	26		A	orange	5
16	A	6											A	yellow	6
17	B	1	48	45	3	38	37	1	20	41	32		A	grey	7
18	B	2	35	36	25	8	37	10	17	13	43		A	white	8
19	B	3	31	23	12	5	29	12	39	39	33		A	black	9
20	B	4	21	34	46	2	20	7	3	10	47		B	blue	10
21	B	5	5	25	4	25	10	5	11	25	48		B	green	11
22	B	6											B	red	12
23	C	1	49	39	3	4	25	12	6	1	22		B	purple	13
24	C	2	33	34	37	33	34	30	30	26	44		B	orange	14
25	C	3	24	43	44	14	21	48	8	6	18		B	yellow	15
26	C	4	17	43	50	49	18	50	38	37	24		B	grey	16
27	C	5	37	34	18	23	48	27	31	15	19		B	white	17
28	C	6											B	black	18
29													C	blue	19
30													C	green	20
31													C	red	21
32													C	purple	22
33													C	orange	23
34													C	yellow	24
35													C	grey	25
36													C	white	26
37													C	black	27
Sheet1