Multiple lookups to return a value

[JannetteChristie]

I have the following data formatted as shown below:

Book1
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
2	TBX.		T06.		T10.		TG12.		TGC12.		T15.		TGC15.		T18.		TG18.
3	0.66	050	0.99	100	1.02	110	1.5	150	2	200	2.5	250	2	200	2.22	230	2	200
4	1.26	100	1.98	200	1.2	120	2	200	2.5	250			2.5	250	3.2	330	2.5	250
5					1.4	150	2.5	250	3	300			3	300	4.15	430	3	300
6					1.6	160	3	300	3.5	350			3.5	350			3.5	350
7					1.8	190	3.5	350	4	400			4	400			4	400
8					2	200	4	400					4.5	450			4.5	450
9					2.35	240	4.5	450									5	500
10					2.55	250	5	500									5.5	550
11					2.91	300											6	600
12																	6.5	650
13																	7	700
14
15
Data

In cell B2 the user will type in one of the values in Row H, in cell b3 one of the values in the matched column (from row H). I am trying to return the next columns value of the same row.
(For example, User inputs TGC12. and 3, should return 300)

 

[AlanY]

try this

Book1
	B	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1
2	TGC12.	TBX.		T06.		T10.		TG12.		TGC12.		T15.		TGC15.		T18.		TG18.
3	3	0.66	50	0.99	100	1.02	110	1.5	150	2	200	2.5	250	2	200	2.22	230	2	200
4	300	1.26	100	1.98	200	1.2	120	2	200	2.5	250			2.5	250	3.2	330	2.5	250
5						1.4	150	2.5	250	3	300			3	300	4.15	430	3	300
6						1.6	160	3	300	3.5	350			3.5	350			3.5	350
7						1.8	190	3.5	350	4	400			4	400			4	400
8						2	200	4	400					4.5	450			4.5	450
9						2.35	240	4.5	450									5	500
10						2.55	250	5	500									5.5	550
11						2.91	300											6	600
12																		6.5	650
13																		7	700
Sheet1

Cell Formulas
Range	Formula
B4	=INDEX($H:$Y,MATCH(B3,INDEX($H:$Y,,MATCH(B2,$H$2:$Y$2,0)),0),MATCH(B2,$H$2:$Y$2,0)+1)

 

[JannetteChristie]

Spot on, thanks very much.

 

[AlanY]

you're welcome