Cross Reference

[RenéTh]

Hey Guys,
thanks for accepting me here. I am quite new in Excel and I face a, in my opinion, quite tricky question.
I have one Excel file with two sheets.

Sheet 1:
[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD][/TD]
[TD]Brazil[/TD]
[TD]Bolivia[/TD]
[TD]Colombia[/TD]
[TD]Chile
[/TD]
[/TR]
[TR]
[TD]JPM EMBI Global
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JPM EMBI+
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2 ("JPM EMBI Global"):
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]JPM EMBI GLOBAL BRAZIL - TOT RETURN IND[/TD]
[TD]JPM EMBI GLOBAL CHILE - TOT RETURN IND[/TD]
[TD]JPM EMBI GLOBAL COLOMBIA - TOT RETURN IND[/TD]
[TD]JPM EMBI GLOBAL BOLIVIA - TOT RETURN IND[/TD]
[/TR]
[TR]
[TD]01.01.1994
[/TD]
[TD]12154[/TD]
[TD]NA[/TD]
[TD]2315[/TD]
[TD]1654[/TD]
[/TR]
[TR]
[TD]01.02.1994
[/TD]
[TD]1258[/TD]
[TD]NA[/TD]
[TD]2156[/TD]
[TD]NA[/TD]
[/TR]
[TR]
[TD]01.03.1994
[/TD]
[TD]514[/TD]
[TD]NA[/TD]
[TD]1564[/TD]
[TD]154
[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet 3 ("JPM EMBI+"):
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]JPM EMBI+ ARGENTINA - TOT RETURN IND[/TD]
[TD]JPM EMBI+ BRAZIL - TOT RETURN IND[/TD]
[TD]JPM EMBI+ COLOMBIA - TOT RETURN IND[/TD]
[TD]JPM EMBI+ UKRAINE - TOT RETURN IND[/TD]
[/TR]
[TR]
[TD]01.01.1994
[/TD]
[TD]12154[/TD]
[TD]NA[/TD]
[TD]2315[/TD]
[TD]1654[/TD]
[/TR]
[TR]
[TD]01.02.1994
[/TD]
[TD]1258[/TD]
[TD]NA[/TD]
[TD]2156[/TD]
[TD]NA[/TD]
[/TR]
[TR]
[TD]01.03.1994
[/TD]
[TD]514[/TD]
[TD]NA[/TD]
[TD]1564[/TD]
[TD]154
[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


My aim is that I can get the data availability for the two rows in sheet 1 ("JPM EMBI Global","JPM EMBI+"). I want to know who many datapoints I have excluding the NA. The reference for the length is the Date (maximum).
I identified two problems:
1. To Identify the correct column because, the JPM EMBI Global covers more countries (columns) as the JPM EMBI+.
2. To match it in that way, that the table in sheet 1 works.

If you need further Information don't hesitate to ask.
Thanks in advance
René