I present this option here to illustrate how the VLOOKUP option is superior.
More than one condition can be tested by nesting IF functions.
Simple currency conversion
To convert from a given currency to other specific currencies, you can use the VLOOKUP function with a lookup table that contains conversion rates. In the example shown, the formula in E5 is: =VLOOKUP(D5,xtable,2,0)*B5 Where "xtable" is the named range G5:H10. As the formula is copied down, it converts the amount in column B from US Dollars (USD) to the currency indicated in column D.
