Extract a value from a table.

G

Guest

hOW CAN i EXTRACT THE EXCHANGE RATE BASED ON CURRENCY AND MONTH?
Here is the example:

EXCHANGE RATES
Currency JAN FEB MAR APR
Belize 0.5076 0.5076 0.5076 0.5076
BP 1.7500 1.7700 1.7800 1.8000
Ca$ 0.7000 0.7000 0.7000 0.7000
CH 0.9000 0.9000 0.9000 0.9000
Euro 1.2700 1.3000 1.3200 1.4000
Honduras 0.0554 0.0555 0.0556 0.0557
Nicaragua 0.0667 0.0665 0.0667 0.0665
USD 1.0000 1.0000 1.0000 1.0000

____________________________________________________
Item Month Currency Lcl Currency Amount in USD
Chocolate JAN Euro 100 Formula?????
Flowers FEB Honduras 1500 Formula?????
Petrol JAN Belize 250 Formula?????
 
J

JulieD

Hi

use INDEX & MATCH functions

assuming your rates are in the range
A1:E10
and the first item you want to find is on row 13, with the month in B13, and
the Currency to convert from in C13
the formula in E13 is:

=INDEX($A$1:$E$10,MATCH(C13,$A$1:$A$10,0),MATCH(B13,$A$1:$E$1,0))*D13

Cheers
JulieD
 
Top