Hello,
I have an formula to enter in the FX column rate for the two currency on a given date, for example per below table 1.1 I want to get the FX rate as on date, when I enter USD or AUD on the currency column, I have created one more excel sheet where I have downloaded all the 2016 FX rate for USD and AUD in the other sheet which shows date and FX rate of AUD and USD and the formula I am using is IF(D11=AUD,VLOOKUP(C11,FX!D4:E202,2,FALSE),IF(D11=USD,VLOOKUP(C11,FX!A4:B223,2,FALSE))), I am not sure if it is correct. if any one can help me.
Thanks,
Table 1.1
<tbody>
</tbody>
I have an formula to enter in the FX column rate for the two currency on a given date, for example per below table 1.1 I want to get the FX rate as on date, when I enter USD or AUD on the currency column, I have created one more excel sheet where I have downloaded all the 2016 FX rate for USD and AUD in the other sheet which shows date and FX rate of AUD and USD and the formula I am using is IF(D11=AUD,VLOOKUP(C11,FX!D4:E202,2,FALSE),IF(D11=USD,VLOOKUP(C11,FX!A4:B223,2,FALSE))), I am not sure if it is correct. if any one can help me.
Thanks,
Table 1.1
Date | Currency | FX Rate |
01/01/2016 | USD | .11111 |
01/01/2016 | AUD | .88888 |
02/08/2016 | USD | .2222 |
02/08/2016 | AUD | .99999 |
<tbody>
</tbody>