Using Index in combination wth Match

[MindManagement]

I am using the table below to fill in the right value from another worksheet called "Call Rates".

	A	B
1	Type Convesation	Fonzer
2	Belgium, Fixed	€ 0,02000
3

<tbody>
</tbody>

The Worksheet Call Rates looks like this

	A	B	C	D
1		Fonzer	Fonzer+	Fonzer++
2	Belgium, Fixed	€ 0,02000	€ 0,01900	€ 0,01800
3	Belgium, Mobile	€ 0,08500	€ 0,06500	€ 0,04500
4

<tbody>
</tbody>

The formula I used in the first table where € 0,02000 is marked in red looks like :
=INDEX('Call Rates'!B2:B4;MATCH(B1&A2;'Call Rates'!B1:D1&'Call Rates'!A2:A4;0))
After that I press Shift+CTRL+Enter
But i get an error saying "# Value".
I used an example from the internet where they looked up a value based on 2 criteria, same as I would like to do.
If I write in the first table 1, in B1, Fonzer++ he should return the value € 0,01800 or Fonzer+ should result in € 0,01900.
But no, it returns the result #Value .
Can somebody tell me what's wrong on my formula ?

 

[RoryA]

You actually want a regular formula rather than an array formula since your criteria are separate - one for the row, one for the column:

=INDEX('Call Rates'!B2:D4;MATCH(A2;'Call Rates'!A2:A4;0);MATCH(B1;'Call Rates'!B1:D1;0))

 

[Scott T]

Try

=INDEX('call rates'!B2:D3;MATCH(A2;'call rates'!A2:A3;0);MATCH(B1;'call rates'!B1:D1;0))

 

[MindManagement]

Wihoe it works- many thanks