If and Vlook up for Currency Converter

[chikku]

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

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>

 

[iliace]

That formula would probably result in a #NAME error. You need to put the currency code in "". Also, you should probably fix the lookup range with $. Like this:

=IF(D11="AUD",VLOOKUP(C11,FX!$D$4:$E$202,2,FALSE),IF(D11="USD",VLOOKUP(C11,FX!$A$4:$B$223,2,FALSE)))

 

[chikku]

That formula would probably result in a #NAME error. You need to put the currency code in "". Also, you should probably fix the lookup range with $. Like this:

=IF(D11="AUD",VLOOKUP(C11,FX!$D$4:$E$202,2,FALSE),IF(D11="USD",VLOOKUP(C11,FX!$A$4:$B$223,2,FALSE)))

Thanks Iliace, it worked.