Multiple MATCH within INDEX function

[dinanochka]

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

 

[Domenic]

Try...

=IF(($G$3<>"USD"),INDEX('FX Table'!$B:$ZZ,MATCH(D$18,'FX Table'!$A:$A,0),MATCH($G$3,'FX Table'!$B$4:$ZZ$4,0)),1)

Hope this helps!