INDEX_Lookup Issue

[BRACE]

Hello,


I'm trying to return the correct value here:

Example:

If I have a height of 2140 and a width of 605, I need the formula to return the value in Cell E7 "375"

I'm currently using INDEX and MATCH but it's not working correctly and in this particular intance its returning "N/A"

A	B	C	D	E	F	G	H	I	J	K	L	M	N
WHITE	400	500	600	700	800	900	1000	1100	1200	1300	1400	1500	1600
1	1000	£304	£304	£304	£304	£304	£324	£324	£324	£324	£374	£374	£374
2	1200	£304	£304	£304	£304	£304	£324	£324	£324	£324	£374	£374	£374
3	1400	£324	£324	£324	£324	£324	£324	£324	£324	£324	£374	£374	£374
4	1600	£324	£324	£324	£324	£324	£324	£324	£324	£324	£374	£374	£374
5	1800	£324	£324	£324	£324	£324	£324	£324	£324	£324	£374	£374	£374
6	2000	£324	£324	£324	£324	£324	£324	£324	£324	£324	£374	£374	£374
7	2200	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374
8	2400	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374
9	2600	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424
10	2800	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424
11	3000	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Arts]

Another option

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	WHITE	400	500	600	700	800	900	1000	1100	1200	1300	1400	1500
2	1000	£304	£304	£304	£304	£304	£324	£324	£324	£324	£374	£374	£374
3	1200	£304	£304	£304	£304	£304	£324	£324	£324	£324	£374	£374	£374		2140	375
4	1400	£324	£324	£324	£324	£324	£324	£324	£324	£324	£374	£374	£374		605
5	1600	£324	£324	£324	£324	£324	£324	£324	£324	£324	£374	£374	£374
6	1800	£324	£324	£324	£324	£324	£324	£324	£324	£324	£374	£374	£374
7	2000	£324	£324	£324	£324	£324	£324	£324	£324	£324	£374	£374	£374
8	2200	£374	£374	£374	£375	£374	£374	£374	£374	£374	£374	£374	£374
9	2400	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374	£374
10	2600	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424
11	2800	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424
12	3000	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424	£424
Data

Cell Formulas
Range	Formula
P3	P3	=INDEX(B2:M12,XMATCH(O3,A2:A12,1),XMATCH(O4,B1:M1,1))

Reading about using the 1 in the XLOOKUP, should this not look up the cross sections at 2000 and 500? "The largest value less than or equal to the lookup value"

2000 less than 2140
500 less than 600

 

[Fluff]

That image is for match, not xmatch or xlookup.

 

[Arts]

Ah I see I thought they (Excel) would have gone with same logic with MATCH and XMATCH.

Thanks!

 

[Fluff]

No, because xmatch is an improved version of match with more capability.