Column 1 contains the Year and Month for each currency.
Column 2 contains each currency, repeated for each year-month group.
Columns 3 through 33 contain the spot rate for each day of the month

I can set up a formula to capture two of the three above variables but run
into trouble when trying to insert a third condition. The below is a sample
of where I can get. The problem is that it finds the first occurrence of the
currency. I need to be able to add the month-year column into the equation.

=INDEX(Sheet5!$A$1:$AG$10000,MATCH(G2,Sheet5!$B$1: $B$10000,0),MATCH(D2,Sheet5!A1:AG1,0))

1
YRMONTH CCY SPOTRATE1_8
200702 AED 3.67265
200702 ARS 3.10375
200702 ATS 10.56940
200702 AUD 0.77375
200702 BBD 2.00000
200702 BEF 30.98180
200702 BMD 1.00150

Thanks for any help you can give.
--
Pops Jackson