Lookup using IF/Match returning wrong values

[sundodger]

Hi Everyone,
I have a table in A22:E26, it has the categories A,B,C,D and E in row 22. In rows 23 to 26 it has values that i want to look up and return in cell B9.
The user inputs the value of the category they are in into B6. Either A,B,C,D or E.
They also input a value into E5, This decides which row the data is returned from. If the value in E5 is 0 to 26000, it would be the data in row 23, 26001 to 39000 Row 24, 39001 to 48000 row 25, 48001 and higher row 26. E.G category C at 48002 would return the value in C26, Category A at 10000 would return the value in A23 an so on.
I am using the formula
=IF(AND(E5>=MIN($K$4:$K$7), E5<=MAX($L$4:$L$7)), INDEX($A$23:$E$26, MATCH(B6, $A$22:$E$22, 0), MATCH(E5, $A$23:$A$26, 1)), "Invalid Input")
Which is the closest i have got to getting this to work.
However i keep getting the wrong cell returned as an answer.
E.G if i have Category D and a value of 27000 it should return the value in D24 but i get the value from A25.
I will try to upload a copy of the sheet later if needed.
Thanks

 

[shift-del]

Hello

Mappe5
	A	B	C	D	E	F
5					27000
6		D
7
8
9		169
10
11
12
13
14
15
16
17
18
19
20
21
22	A	B	C	D	E
23	348	103	215	90	365	0
24	129	248	78	169	112	26001
25	146	262	105	350	271	39001
26	89	286	169	164	321	48001
Tabelle1

Cell Formulas
Range	Formula
B9	B9	=CHOOSECOLS(XLOOKUP(E5,F23:F26,A23:E26,,-1,1),XMATCH(B6,A22:E22))

 

[sundodger]

That worked perfectly, Thanks for your help it was starting to drive me mad.