dinanochka
New Member
- Joined
- Sep 22, 2015
- Messages
- 1
Hello,
I need to pull various exchange rates that are located in a separate worksheet (FX Table), and which must correspond to a) a certain date and b) a certain currency. The formula below seem to only account for the date, and omits the currency ticker.
D18 is the date
G3 is the currency
Row 4 in FX Table contains all currency tickers (hence B4:ZZ4)
=IF(($G$3<>"USD"),INDEX('FX Table'!$B:$B,MATCH(D$18,'FX Table'!$A:$A,0),MATCH($G$3,'FX Table'!$B$4:$ZZ$4,0)),1)
I am using Excel 2011
I need to pull various exchange rates that are located in a separate worksheet (FX Table), and which must correspond to a) a certain date and b) a certain currency. The formula below seem to only account for the date, and omits the currency ticker.
D18 is the date
G3 is the currency
Row 4 in FX Table contains all currency tickers (hence B4:ZZ4)
=IF(($G$3<>"USD"),INDEX('FX Table'!$B:$B,MATCH(D$18,'FX Table'!$A:$A,0),MATCH($G$3,'FX Table'!$B$4:$ZZ$4,0)),1)
I am using Excel 2011
Last edited: