Index Match Error

[Melimob]

Hi

I have a table

Country	Client Notification Date
BRAZIL	31-May-19
CHILE	20-Aug-19
INDONESIA
ISRAEL
MALAYSIA	02-Sep-19
NEW ZEALAND
PANAMA
PERU
PHILIPPINES
SAUDI ARABIA
SOUTH AFRICA
TURKEY
UAE (DUBAI)
VIETNAM

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

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:

Timeline	Column1	BRAZIL
Client Notification Date		#N/A

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

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 =

	A	B
1	TPN to TPN	Client Notification Date
2	BRAZIL	31-May-19
3	CHILE	20-Aug-19

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

Table I'm entering to and what the result in

A B C D 1 Timeline Column1 BRAZIL CHILE 2 Client Notification Date Wk 1 31-May-19 20-Aug-19 <colgroup><col><col><col span="3"></colgroup><tbody> </tbody>

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

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.