Index Match Error with date range

[SAXON10]

Good afternoon,

I am trying to apply the following formula in B17=IFERROR(INDEX($B$2:$F$11,MATCH($B16,$B$1:$F$1,0),MATCH($A17,$A$2:$A$11,0)),"") but i got error.

How to fix the error. Please help me.

Data range: A1:F11

DATA;

DATE	UK	US	EU	ASIA	CHINA
01/01/2018	10	11	12	1	14
02/01/2018	34	35	36	25	38
03/01/2018	58	59	60	49	62
04/01/2018	82	83	84	73	86
05/01/2018	106	107	108	97	110
06/01/2018	130	131	132	121	134
07/01/2018	154	155	156	145	158
08/01/2018	178	179	180	169	182
09/01/2018	202	203	204	193	206
10/01/2018	226	227	228	217	230

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

RESULT;

DATE	UK	US	EU	ASIA	CHINA
05/02/2018	106	107	108	97	110

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[markmzz]

Maybe this:

=IFERROR(INDEX($B$2:$F$11,MATCH($A17,$A$2:$A$11,0),MATCH(B$16,$B$1:$F$1,0)),"")

Markmzz

 

[Marcílio_Lobão]

SAXON10, Good morning.

You changed the position of the row argument with the column argument.
Only that.

Try to use:

=IFERROR(INDEX($B$2:$F$11,MATCH($A$17,$A$2:$A$11,0), MATCH(B$16,$B$1:$F$1,0)),"")

Detailing:

Row--> MATCH($A$17,$A$2:$A$11,0)

Column --> MATCH(B$16,$B$1:$F$1,0)

Attention where to put the sign of $

Is that what you want?
I hope it helps you.

 

[markmzz]

Another formula with the same result (with your example):

=IFERROR(VLOOKUP($A17,$A$2:$F$11,MATCH(B$16,$A$1:$F$1,0),0),"")

Markmzz

 

[SAXON10]

Markmzz ​

& Marcílio_Lobão

​

Thank for your help formulas working fine.