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".

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Type Convesation
[/TD]
[TD]Fonzer
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Belgium, Fixed
[/TD]
[TD]€ 0,02000
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The Worksheet Call Rates looks like this
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD]Fonzer
[/TD]
[TD]Fonzer+
[/TD]
[TD]Fonzer++
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Belgium, Fixed
[/TD]
[TD]€ 0,02000
[/TD]
[TD]€ 0,01900
[/TD]
[TD]€ 0,01800
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Belgium, Mobile
[/TD]
[TD]€ 0,08500
[/TD]
[TD]€ 0,06500
[/TD]
[TD]€ 0,04500
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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