Calculation/formula needed for a specific type of chart/data sheet I have

[greddy2die]

Hi again,

I really appreciate everyone's help in the past & i'm back for more! haha, sorrrry.

Is there a relatively easy formula or some kind of calculation that, lets say for instance, if I put in B1 "7" & B2 "11" it would know to pull the price ($3.40) where those 2 numbers intersect? I'm trying to put together this calculator for an office of mine to help speed up their productivity and this rate sheet I have has me stumped since i'm very much an excel novice.

The rate needed will vary greatly depending on which 2 "zones" someone chooses. I dont want to put an IF formula for every single box below.

ZONE 1	7
ZONE 2	11												ZONE 2
		ZONE	1	2	2A	3	4	5	6	7	8	SA	9	10	11	12	12A	13	14	15	16	17	18	19	20	Stream
		1	$2.50	$2.71	$3.79	$3.35	$3.51	$2.07	$3.40	$2.60	$2.02	$4.72	$1.92	$2.93	$1.97	$3.19	$3.35	$3.35	$3.56	$3.72	$3.40	$1.92	$2.02	$3.56	$1.92	$1.92
		2	$2.71	$2.60	$3.64	$3.35	$3.51	$2.45	$5.31	$4.62	$2.28	$4.78	$2.28	$3.19	$2.66	$3.72	$3.72	$3.35	$3.56	$3.72	$3.40	$2.14	$2.02	$3.56	$1.92	$2.14
		2A	$3.79	$3.64	$3.64	$3.70	$4.20	$3.43	$5.60	$6.00	$3.19	$6.00	$3.19	$3.55	$3.72	$5.20	$5.20	$4.69	$4.98	$5.20	$4.26	$2.99	$3.10	$4.98	$2.90	$2.99
		3	$3.35	$3.35	$3.70	$2.93	$3.35	$3.29	$5.31	$3.51	$2.66	$4.89	$2.66	$3.35	$3.03	$3.72	$3.72	$3.72	$3.77	$3.72	$3.77	$2.76	$2.87	$3.72	$2.76	$2.76
		4	$4.20	$4.20	$4.20	$4.90	$4.21	$4.21	$5.16	$5.50	$3.90	$5.50	$4.05	$4.75	$4.69	$4.78	$6.15	$4.95	$5.16	$5.75	$4.42	$3.99	$4.09	$5.22	$3.90	$3.99
		5	$2.07	$2.45	$3.43	$3.29	$3.51	$2.50	$4.36	$2.50	$2.50	$4.94	$2.66	$4.46	$2.66	$3.72	$3.99	$3.51	$3.61	$3.72	$2.82	$1.65	$1.87	$3.56	$1.87	$1.65
		6	$3.40	$5.31	$5.60	$5.31	$4.46	$4.36	$4.41	$3.61	$2.60	$4.25	$3.46	$4.14	$4.78	$4.46	$4.46	$4.52	$4.78	$4.78	$4.36	$4.46	$4.52	$5.58	$4.19	$4.09
		7	$2.60	$4.62	$6.00	$3.51	$4.04	$2.50	$3.61	$4.46	$2.50	$4.30	$2.66	$3.40	$3.40	$3.72	$3.77	$3.77	$3.88	$4.04	$3.77	$4.19	$4.62	$4.36	$2.34	$3.61
ZONE 1	8	$2.02	$2.28	$3.19	$2.66	$3.13	$2.50	$3.13	$2.50	$1.81	$4.72	$1.81	$3.40	$2.40	$3.72	$3.72	$3.72	$3.03	$3.61	$2.93	$1.70	$1.87	$3.93	$1.65	$1.70	8
		8A	$4.72	$4.78	$6.00	$4.89	$4.94	$4.94	$3.72	$4.30	$4.72	$4.72	$4.62	$4.67	$4.72	$4.78	$4.78	$4.67	$4.67	$4.78	$4.89	$4.62	$4.67	$5.10	$4.62	$4.62
		9	$1.92	$2.28	$3.19	$2.66	$3.35	$2.66	$3.46	$2.66	$1.81	$4.62	$2.50	$2.93	$2.60	$3.99	$4.04	$3.35	$3.51	$3.72	$3.61	$1.87	$1.97	$2.82	$1.92	$1.87
		10	$2.93	$3.13	$3.55	$3.35	$4.09	$4.46	$4.14	$3.40	$3.40	$4.67	$2.93	$3.72	$3.72	$3.72	$3.93	$3.83	$4.06	$3.72	$3.77	$2.93	$3.08	$3.35	$2.93	$2.93
		11	$1.97	$2.66	$3.72	$3.03	$3.99	$2.66	$4.78	$3.40	$2.40	$4.72	$2.60	$3.72	$2.28	$3.51	$3.56	$3.08	$4.25	$3.56	$3.61	$1.87	$2.87	$2.87	$2.02	$1.87
		12	$3.13	$3.72	$5.20	$3.72	$4.04	$3.72	$4.46	$3.72	$3.72	$4.78	$3.99	$3.72	$3.51	$3.56	$3.72	$3.72	$3.77	$4.46	$4.19	$3.40	$3.77	$3.77	$3.35	$3.40
		12A	$3.35	$3.72	$5.20	$3.72	$5.47	$3.99	$4.46	$3.72	$3.72	$4.78	$4.04	$3.99	$3.56	$3.72	$3.93	$3.88	$3.99	$4.46	$4.46	$4.41	$4.52	$4.94	$4.04	$4.41
		13	$3.35	$3.35	$4.69	$3.72	$4.25	$3.51	$4.52	$3.72	$3.72	$4.67	$3.35	$3.83	$3.08	$3.72	$3.88	$3.72	$3.72	$4.46	$3.56	$3.03	$3.08	$3.08	$2.93	$3.08
		14	$3.56	$3.56	$4.98	$3.72	$4.46	$3.61	$4.78	$3.72	$3.72	$4.72	$3.51	$4.06	$3.13	$3.77	$3.99	$3.72	$3.72	$4.46	$3.61	$3.44	$3.29	$2.93	$3.72	$2.93
		15	$3.72	$3.72	$5.20	$3.72	$5.05	$3.72	$4.78	$4.04	$3.83	$4.78	$3.72	$3.72	$3.56	$4.46	$4.46	$4.46	$4.46	$4.04	$3.61	$4.57	$4.04	$4.36	$4.04	$3.88
		16	$3.40	$3.40	$4.26	$3.72	$3.72	$2.82	$4.36	$3.72	$3.88	$4.89	$3.61	$3.77	$3.61	$4.19	$4.41	$3.56	$3.61	$3.61	$2.82	$4.52	$4.52	$3.29	$3.29	$2.76
		17	$1.92	$2.14	$2.99	$2.76	$3.99	$1.65	$4.46	$4.25	$1.70	$4.62	$1.87	$2.93	$1.87	$3.40	$4.41	$3.08	$3.44	$4.57	$4.41	$1.60	$1.87	$3.72	$1.92	o.oc
		18	$2.02	$2.02	$3.10	$2.87	$3.51	$1.87	$4.52	$4.62	$1.87	$4.67	$1.97	$3.08	$1.97	$3.56	$4.52	$3.08	$3.29	$4.04	$4.52	$1.87	$1.92	$3.88	$2.02	0.00 ·
		19	$3.56	$3.56	$4.98	$3.72	$4.52	$3.56	$5.58	$4.36	$3.93	$5.10	$2.82	$3.35	$2.87	$3.77	$4.94	$3.08	$2.93	$4.36	$3.29	$3.72	$3.88	$1.92	$3.56	$0.00
		20	$1.92	$1.92	$2.90	$2.76	$3.03	$1.87	$4.19	$2.28	$1.65	$4.62	$1.92	$2.93	$2.02	$3.35	$4.04	$2.93	$3.72	$4.04	$3.29	$1.92	$2.02	$3.56	$1.87	$0.00

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	ZONE 1	7	3.4
2	ZONE 2	11												ZONE 2
3			ZONE	1	2	2A	3	4	5	6	7	8	SA	9	10	11	12	12A	13	14	15	16	17	18	19	20	Stream
4			1	2.5	2.71	3.79	3.35	3.51	2.07	3.4	2.6	2.02	4.72	1.92	2.93	1.97	3.19	3.35	3.35	3.56	3.72	3.4	1.92	2.02	3.56	1.92	1.92
5			2	2.71	2.6	3.64	3.35	3.51	2.45	5.31	4.62	2.28	4.78	2.28	3.19	2.66	3.72	3.72	3.35	3.56	3.72	3.4	2.14	2.02	3.56	1.92	2.14
6			2A	3.79	3.64	3.64	3.7	4.2	3.43	5.6	6	3.19	6	3.19	3.55	3.72	5.2	5.2	4.69	4.98	5.2	4.26	2.99	3.1	4.98	2.9	2.99
7			3	3.35	3.35	3.7	2.93	3.35	3.29	5.31	3.51	2.66	4.89	2.66	3.35	3.03	3.72	3.72	3.72	3.77	3.72	3.77	2.76	2.87	3.72	2.76	2.76
8			4	4.2	4.2	4.2	4.9	4.21	4.21	5.16	5.5	3.9	5.5	4.05	4.75	4.69	4.78	6.15	4.95	5.16	5.75	4.42	3.99	4.09	5.22	3.9	3.99
9			5	2.07	2.45	3.43	3.29	3.51	2.5	4.36	2.5	2.5	4.94	2.66	4.46	2.66	3.72	3.99	3.51	3.61	3.72	2.82	1.65	1.87	3.56	1.87	1.65
10			6	3.4	5.31	5.6	5.31	4.46	4.36	4.41	3.61	2.6	4.25	3.46	4.14	4.78	4.46	4.46	4.52	4.78	4.78	4.36	4.46	4.52	5.58	4.19	4.09
11			7	2.6	4.62	6	3.51	4.04	2.5	3.61	4.46	2.5	4.3	2.66	3.4	3.4	3.72	3.77	3.77	3.88	4.04	3.77	4.19	4.62	4.36	2.34	3.61
12	ZONE 1	8	2.02	2.28	3.19	2.66	3.13	2.5	3.13	2.5	1.81	4.72	1.81	3.4	2.4	3.72	3.72	3.72	3.03	3.61	2.93	1.7	1.87	3.93	1.65	1.7	8
13			8A	4.72	4.78	6	4.89	4.94	4.94	3.72	4.3	4.72	4.72	4.62	4.67	4.72	4.78	4.78	4.67	4.67	4.78	4.89	4.62	4.67	5.1	4.62	4.62
14			9	1.92	2.28	3.19	2.66	3.35	2.66	3.46	2.66	1.81	4.62	2.5	2.93	2.6	3.99	4.04	3.35	3.51	3.72	3.61	1.87	1.97	2.82	1.92	1.87
15			10	2.93	3.13	3.55	3.35	4.09	4.46	4.14	3.4	3.4	4.67	2.93	3.72	3.72	3.72	3.93	3.83	4.06	3.72	3.77	2.93	3.08	3.35	2.93	2.93
16			11	1.97	2.66	3.72	3.03	3.99	2.66	4.78	3.4	2.4	4.72	2.6	3.72	2.28	3.51	3.56	3.08	4.25	3.56	3.61	1.87	2.87	2.87	2.02	1.87
17			12	3.13	3.72	5.2	3.72	4.04	3.72	4.46	3.72	3.72	4.78	3.99	3.72	3.51	3.56	3.72	3.72	3.77	4.46	4.19	3.4	3.77	3.77	3.35	3.4
18			12A	3.35	3.72	5.2	3.72	5.47	3.99	4.46	3.72	3.72	4.78	4.04	3.99	3.56	3.72	3.93	3.88	3.99	4.46	4.46	4.41	4.52	4.94	4.04	4.41
19			13	3.35	3.35	4.69	3.72	4.25	3.51	4.52	3.72	3.72	4.67	3.35	3.83	3.08	3.72	3.88	3.72	3.72	4.46	3.56	3.03	3.08	3.08	2.93	3.08
20			14	3.56	3.56	4.98	3.72	4.46	3.61	4.78	3.72	3.72	4.72	3.51	4.06	3.13	3.77	3.99	3.72	3.72	4.46	3.61	3.44	3.29	2.93	3.72	2.93
21			15	3.72	3.72	5.2	3.72	5.05	3.72	4.78	4.04	3.83	4.78	3.72	3.72	3.56	4.46	4.46	4.46	4.46	4.04	3.61	4.57	4.04	4.36	4.04	3.88
22			16	3.4	3.4	4.26	3.72	3.72	2.82	4.36	3.72	3.88	4.89	3.61	3.77	3.61	4.19	4.41	3.56	3.61	3.61	2.82	4.52	4.52	3.29	3.29	2.76
23			17	1.92	2.14	2.99	2.76	3.99	1.65	4.46	4.25	1.7	4.62	1.87	2.93	1.87	3.4	4.41	3.08	3.44	4.57	4.41	1.6	1.87	3.72	1.92	o.oc
24			18	2.02	2.02	3.1	2.87	3.51	1.87	4.52	4.62	1.87	4.67	1.97	3.08	1.97	3.56	4.52	3.08	3.29	4.04	4.52	1.87	1.92	3.88	2.02	0.00 ·
25			19	3.56	3.56	4.98	3.72	4.52	3.56	5.58	4.36	3.93	5.1	2.82	3.35	2.87	3.77	4.94	3.08	2.93	4.36	3.29	3.72	3.88	1.92	3.56	0
26			20	1.92	1.92	2.9	2.76	3.03	1.87	4.19	2.28	1.65	4.62	1.92	2.93	2.02	3.35	4.04	2.93	3.72	4.04	3.29	1.92	2.02	3.56	1.87	0
Sheet2

Cell Formulas
Range	Formula
C1	C1	=INDEX(D4:AA26,MATCH(B1,C4:C26,0),MATCH(B2,D3:AA3,0))

 

[greddy2die]

thank you!

 

[Fluff]

You're welcome.