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;
[TABLE="width: 536"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]UK[/TD]
[TD]US[/TD]
[TD]EU[/TD]
[TD]ASIA[/TD]
[TD]CHINA[/TD]
[/TR]
[TR]
[TD]01/01/2018[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]1[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]02/01/2018[/TD]
[TD]34[/TD]
[TD]35[/TD]
[TD]36[/TD]
[TD]25[/TD]
[TD]38[/TD]
[/TR]
[TR]
[TD]03/01/2018[/TD]
[TD]58[/TD]
[TD]59[/TD]
[TD]60[/TD]
[TD]49[/TD]
[TD]62[/TD]
[/TR]
[TR]
[TD]04/01/2018[/TD]
[TD]82[/TD]
[TD]83[/TD]
[TD]84[/TD]
[TD]73[/TD]
[TD]86[/TD]
[/TR]
[TR]
[TD]05/01/2018[/TD]
[TD]106[/TD]
[TD]107[/TD]
[TD]108[/TD]
[TD]97[/TD]
[TD]110[/TD]
[/TR]
[TR]
[TD]06/01/2018[/TD]
[TD]130[/TD]
[TD]131[/TD]
[TD]132[/TD]
[TD]121[/TD]
[TD]134[/TD]
[/TR]
[TR]
[TD]07/01/2018[/TD]
[TD]154[/TD]
[TD]155[/TD]
[TD]156[/TD]
[TD]145[/TD]
[TD]158[/TD]
[/TR]
[TR]
[TD]08/01/2018[/TD]
[TD]178[/TD]
[TD]179[/TD]
[TD]180[/TD]
[TD]169[/TD]
[TD]182[/TD]
[/TR]
[TR]
[TD]09/01/2018[/TD]
[TD]202[/TD]
[TD]203[/TD]
[TD]204[/TD]
[TD]193[/TD]
[TD]206[/TD]
[/TR]
[TR]
[TD]10/01/2018[/TD]
[TD]226[/TD]
[TD]227[/TD]
[TD]228[/TD]
[TD]217[/TD]
[TD]230[/TD]
[/TR]
</tbody>[/TABLE]

RESULT;

[TABLE="width: 536"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]UK[/TD]
[TD]US[/TD]
[TD]EU[/TD]
[TD]ASIA[/TD]
[TD]CHINA[/TD]
[/TR]
[TR]
[TD]05/02/2018[/TD]
[TD]106[/TD]
[TD]107[/TD]
[TD]108[/TD]
[TD]97[/TD]
[TD]110[/TD]
[/TR]
</tbody>[/TABLE]

 

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