Looup Exchange Rates over begin and end dates and country

[Marc Enzi]

Group,
I have a set of daily exchange rate data spanning one year. It has been a long time since I've done this and I am really struggling...
Data Set
A............... B............C...........D
Date.......... CAD.........EUR........GBP
01/01/2016 0.722932 1.086970 1.473860
01/02/2016 0.722932 1.086970 1.473860
01/03/2016 0.722932 1.086970 1.473860
01/04/2016 0.719057 1.086640 1.473360
01/05/2016 0.717226 1.078690 1.469320
.
.
12/31/2016 0.743959 1.052040 1.234120

I am given a Begin_date and an End_date and a CURRENCY, I need to find the average exchange rate to $USD over the range of dates for the Selected Currency.

Input Sheet

A...............B...............C..............D
Begin_Date End_Date CURRENCY RESULT
01/03/2016 01/05/2016 EUR 1.084100

Your help is greatly appreciated.

 

[Marcelo Branco]

Assuming data in Sheet data in range A1:D366 (headers in row 1)

Maybe this
D2 of Input
=AVERAGEIFS(INDEX(Data!B2:D366,0,MATCH(C2,Data!B1:D1,0)),Data!A2:A366,">="&A2,Data!A2:A366,"<="&B2)

Hope this helps

M.

 

[Marc Enzi]

Marcelo,
Thank you very much. This is exactly what I needed.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.