Index Match Match returning N/A please assistance is needed?

[Waffles255]

Hi Gents, i am trying to make a dynamic lookup but keep getting a N/A error i wrecked my brain but cannot seem to spot the problem, any help would greatly be appreciated?

Matrix Test.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Transfers Prices calculator
2
3		From	To	Number of pax	Total Cost Price				Helper lookup	Lookup Value
4		Johannesburg	Nelspruit	5	#N/A				JohannesburgNelspruit	7
5		Makuleke Camp	Johannesburg	17					Makuleke CampJohannesburg	22
6		Johannesburg	Johannesburg	17					JohannesburgJohannesburg	22
7		Johannesburg	Johannesburg	17					JohannesburgJohannesburg	22
8		Johannesburg	Johannesburg	17					JohannesburgJohannesburg	22
9										3
10										3
11										3
12										3
13										3
14										3
15										3
16
17
18
19
20
21		From	3	7	13	22
22		JohannesburgMakuleke Camp	R 4,800.00	R 6,800.00	R 9,000.00	R 13,500.00
23		JohannesburgMashatu Camp	R 4,200.00	R 6,400.00	R 8,000.00	R 13,000.00
24		JohannesburgSelati Camp	R 4,000.00	R 6,000.00	R 7,500.00	R 12,500.00
25		JohannesburgKarongwe Camp	R 3,800.00	R 5,500.00	R 6,750.00	R 12,000.00
26		JohannesburgPridelands Camp	R 3,800.00	R 5,500.00	R 6,750.00	R 12,000.00
27		JohannesburgHoedspruit	R 3,800.00	R 5,500.00	R 6,750.00	R 12,000.00
28		JohannesburgEast Gate Airport	R 4,000.00	R 5,800.00	R 6,750.00	R 12,500.00
29		JohannesburgNelspruit	R 3,200.00	R 4,400.00	R 5,200.00	R 9,500.00
30
Input Sheet PFG

Cell Formulas
Range	Formula
E4	E4	=INDEX(B21:F29,MATCH(J4,B21:F21,0)*MATCH(I4,B21:B29,0))
J4:J15	J4	=IFS(D4<=3,"3",D4<=7,"7",D4<=13,"13",D4<=22,"22")
I5:I15	I5	=B5&C5

Cells with Data Validation
Cell	Allow	Criteria
B4:C15	List	='Data Table'!$K$4:$K$12

 

[RoryA]

Your numbers in column J are actually text. Remove the quotes in the formula:

=IFS(D4<=3,3,D4<=7,7,D4<=13,13,D4<=22,22)

Additionally, you need two separate MATCH functions, not a multiplication:

=INDEX($C$22:$F$29,MATCH(I4,$B$22:$B$29,0),MATCH(J4,$C$21:$F$21,0))

 

[Waffles255]

Thanks i get it, thanks so much for this!!