Variable Values with a Lookup Table

[rcb007]

I am trying to use this lookup table so that it can be dynamic, so I do not have to create separate tables as shown below.
The purpose of the table is to generate a value for H (dia).

It uses the Q Value to be compared to the Full Value to get the desired Dia Value.

In this example (The First Table to the Left),

Q value from Colum E needs to fall in between the values in Column B (min) and Column C (max) to show the Column A (dia) Result.



The Area from I3 through K6 is the work area. I can supply the Q and Slope, but I need the dia value from that.
I did not know if there was a way to use one table instead of creating all these other tables to generate the (dia) Result.

thank you for any help and sorry if this seems very confusing. I tried my best to color coordinate between everything.

 

[GraH]

It's a pity your data is in a picture.
Maybe this Xlookup works? I could not enter all the data, so I picked a few lines.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	dia	min	Full	n	Q	Slope			Q	dia	Slope
2	12	0	1,78	0,013	5,2	0,25			0	0	0,25
3	15	1,78	3,23	0,013	5,2	0,25			5,2	18	0,25
4	18	3,23	5,25	0,013	5,2	0,25			6,2	18	0,5
5	18	4,57	7,43	0,013	6,2	0,5			9,2	21	0,75
6	21	9,1	13,72	0,013	9,2	0,75			10,2	21	0,75
7	24	13,72	19,58	0,013	9,2	0,75
Sheet1

Cell Formulas
Range	Formula
F2:F7	F2	=XLOOKUP(A2:A7&"-"&E2:E7,$J$2:$J$6&"-"&$I$2:$I$6,$K$2:$K$6,,-1)
Dynamic array formulas.

 

[rcb007]

Q Comparison.xlsx
	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
1	dia	min	Full	n	Q	Slope								dia	min	Full	n	Q	Slope		dia	min	Full	n	Q	Slope
2	12	0	1.78	0.013	5.20	0.25			Q	dia	Slope			12	0	2.52	0.013	6.20	0.50		12	0	3.09	0.013	9.20	0.75
3	15	1.78	3.23	0.013	5.20	0.25		1	5.2	18	0.25			15	2.52	4.57	0.013	6.20	0.50		15	3.09	5.59	0.013	9.20	0.75
4	18	3.23	5.25	0.013	5.20	0.25		2	6.2	18	0.5			18	4.57	7.43	0.013	6.20	0.50		18	5.59	9.10	0.013	9.20	0.75
5	21	5.25	7.92	0.013	5.20	0.25		3	9.2	21	0.75			21	7.43	11.20	0.013	6.20	0.50		21	9.10	13.72	0.013	9.20	0.75
6	24	7.92	11.31	0.013	5.20	0.25		4	10.2	21	0.75			24	11.20	16.00	0.013	6.20	0.50		24	13.72	19.59	0.013	9.20	0.75
7	30	11.31	20.51	0.013	5.20	0.25				LOOKUP(H3,C2:C14,A2:A14)				30	16.00	29.00	0.013	6.20	0.50		30	19.59	35.52	0.013	9.20	0.75
8	36	20.51	33.35	0.013	5.20	0.25								36	29.00	47.16	0.013	6.20	0.50		36	35.52	57.76	0.013	9.20	0.75
9	42	33.35	50.30	0.013	5.20	0.25			Q	Variable				42	47.16	71.14	0.013	6.20	0.50		42	57.76	87.13	0.013	9.20	0.75
10	48	50.30	71.82	0.013	5.20	0.25			Slope	Variable				48	71.14	101.57	0.013	6.20	0.50		48	87.13	124.40	0.013	9.20	0.75
11	54	71.82	98.32	0.013	5.20	0.25								54	101.57	139.05	0.013	6.20	0.50		54	124.40	170.30	0.013	9.20	0.75
12	60	98.32	130.22	0.013	5.20	0.25								60	139.05	184.16	0.013	6.20	0.50		60	170.30	225.55	0.013	9.20	0.75
13	66	130.22	167.90	0.013	5.20	0.25								66	184.16	237.45	0.013	6.20	0.50		66	225.55	290.82	0.013	9.20	0.75
14	72	167.90	211.75	0.013	5.20	0.25								72	237.45	299.47	0.013	6.20	0.50		72	290.82	366.77	0.013	9.20	0.75
15	dia	min	Full	n	Q	Slope								dia	min	Full	n	Q	Slope		dia	min	Full	n	Q	Slope
16
17
Sheet1

Cell Formulas
Range	Formula
C2:C14,W2:W14,P2:P14	C2	=IF(SUM(A2:A2)=0,"-",(1.486/D2)*((A2^2)*PI()/576)*((A2/48)^(2/3))*((F2/100)^(1/2)))
B3:B14,V3:V14,O3:O14	B3	=C2
J3	J3	=LOOKUP(I3,B2:B14,A2:A14)
J4	J4	=LOOKUP(I4,O2:O14,N2:N14)
J5	J5	=LOOKUP(I5,V2:V14,U2:U14)
J6	J6	=LOOKUP(I6,$C$2:$C$14,$A$2:$A$14)