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:

	Brazil	Bolivia	Colombia	Chile
JPM EMBI Global
JPM EMBI+

<tbody>
</tbody>

Sheet 2 ("JPM EMBI Global"):

	JPM EMBI GLOBAL BRAZIL - TOT RETURN IND	JPM EMBI GLOBAL CHILE - TOT RETURN IND	JPM EMBI GLOBAL COLOMBIA - TOT RETURN IND	JPM EMBI GLOBAL BOLIVIA - TOT RETURN IND
01.01.1994	12154	NA	2315	1654
01.02.1994	1258	NA	2156	NA
01.03.1994	514	NA	1564	154
...	...			...

<tbody>
</tbody>

Sheet 3 ("JPM EMBI+"):

	JPM EMBI+ ARGENTINA - TOT RETURN IND	JPM EMBI+ BRAZIL - TOT RETURN IND	JPM EMBI+ COLOMBIA - TOT RETURN IND	JPM EMBI+ UKRAINE - TOT RETURN IND
01.01.1994	12154	NA	2315	1654
01.02.1994	1258	NA	2156	NA
01.03.1994	514	NA	1564	154
...	...			...

<tbody>
</tbody>

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é