Index Match Error

[Melimob]

Hi

I have a table

[TABLE="width: 154"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Country[/TD]
[TD]Client Notification Date[/TD]
[/TR]
[TR]
[TD]BRAZIL[/TD]
[TD]31-May-19[/TD]
[/TR]
[TR]
[TD]CHILE[/TD]
[TD]20-Aug-19[/TD]
[/TR]
[TR]
[TD]INDONESIA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]ISRAEL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MALAYSIA[/TD]
[TD]02-Sep-19[/TD]
[/TR]
[TR]
[TD]NEW ZEALAND[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PANAMA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PERU[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]PHILIPPINES[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SAUDI ARABIA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SOUTH AFRICA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TURKEY[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]UAE (DUBAI)[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]VIETNAM[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

I want to read the date matching on the Country and return the notification date.

My table that I am inputting this in to is formatted as:

[TABLE="width: 218"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Timeline[/TD]
[TD]Column1[/TD]
[TD]BRAZIL[/TD]
[/TR]
[TR]
[TD]Client Notification Date[/TD]
[TD] [/TD]
[TD]#N/A[/TD]
[/TR]
</tbody>[/TABLE]

Here's the formula that I tried and also tried to switch the match criteria round.
But still get an error.

=INDEX(Table3[[#All],[ABC to XYZ]:[Client Notification Date]],MATCH([@Timeline],Table3[Client Notification Date],0),MATCH(Table5[[#Headers],[BRAZIL]],Table3[[#All],[ABC to XYZ]],0))

also - there are two tables with countries so I want to say, if you can't find the country on one table, check the other.
Both tables containing countries as list are formatted the same.

many thanks for any advice!

 

[thekingswolf]

for the two tables check you could just wrap your index matches in an iferror.

for the others, i'm having trouble following your table/naming conventions. can you post a screen of the actual table or upload the sheet?

 

[Melimob]

for the two tables check you could just wrap your index matches in an iferror.

for the others, i'm having trouble following your table/naming conventions. can you post a screen of the actual table or upload the sheet?

thanks for reply...sorry if unclear

Table 3 =


[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl6461, width: 64"] [/TD]
[TD="class: xl6461, width: 64"]A[/TD]
[TD="class: xl6461, width: 64"]B[/TD]
[/TR]
[TR]
[TD="class: xl6461, align: right"]1[/TD]
[TD="class: xl6457"]TPN to TPN[/TD]
[TD="class: xl6458, width: 64"]Client Notification Date[/TD]
[/TR]
[TR]
[TD="class: xl6461, align: right"]2[/TD]
[TD="class: xl6459"]BRAZIL[/TD]
[TD="class: xl6460"]31-May-19[/TD]
[/TR]
[TR]
[TD="class: xl6461, align: right"]3[/TD]
[TD="class: xl6459"]CHILE[/TD]
[TD="class: xl6460"]20-Aug-19
[/TD]
[/TR]
</tbody>[/TABLE]

Table I'm entering to and what the result in

[TABLE="width: 339"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD] [TABLE="width: 403"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Timeline[/TD]
[TD]Column1[/TD]
[TD]BRAZIL[/TD]
[TD]CHILE[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Client Notification Date[/TD]
[TD]Wk 1[/TD]
[TD]31-May-19[/TD]
[TD]20-Aug-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So result for Brazil should be 31 May and Chile 20 Aug

thanks so much for any advice

 

[Melimob]

Don't worry - I over complicated it. A simple VLOOKUP worked fine for me.
sorry to waste you time but thank you for replying.