sumproduct with vlookup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi, I have a table with amount in different currencies. I'd like to
add them using a exchange rate.

The table looks like this:

A1 B C D E
2
3 LCY
4 2009 E2 EUR 500
5 2009 E2 EUR 500
6 2009 E2 EUR 500
7 2009 E2 JPY 10000
8 2009 E2 JPY 10000
9 2009 E2 JPY 10000
10
11 31,500
12
13 EUR JPY
14 2009E2 0.5 65
15 200901 0.55 70


this is what I have up to now: =SUMPRODUCT(--(1/HLOOKUP
(D4:D9,B13:D14,2,FALSE))*(E4:E9))

this only uses the EUR 2009E2 rate (0.5) and gives me an answer og
63000. Correct answer should be 3,462

Can this be solved?

Cheers,

Harold

.

Relevant Pages

  • Re: How can wizards be so TOTALLY stupid about muggle stuff?
    ... An exchange rate is an exchange rate, it doesn't matter which direction it ... has to be a fairly large amount of cross-pollination in that regard. ... in order to get the large amount of food they would need. ... The matter of food creation isn't as clearcut as you put it... ...
    (alt.fan.harry-potter)
  • Re: can vlookup look up the result of a function?
    ... J3 contains your original exchange rate. ... Say J4 contained the amount of increase you're looking for. ... "RagDyer" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Converting dollars into euros
    ... Just multiply the amount by the exchange rate. ... SO if the amount is in A1, and the exchange rate is in C3 on Sheet2, use ... dollars and see the amount in euros in the same cell. ...
    (microsoft.public.excel)
  • Re: Malaysia Ringgit Falls, Funds Out and Party Over?
    ... Remember those days when the exchange rate was RM2.50 to USD1.00? ... happy everyone would be if that currency rate remains, if not better, till ... Considering that the amount of things we can buy today doesn't ...
    (soc.culture.malaysia)
  • Re: SB 900 better?
    ... reliable standard for value--this is the mistake that the Spanish made ... invert the question and compare relative purchasing power of currencies. ... the exchange rate which equates the price of a basket of identical traded ...
    (rec.photo.digital.slr-systems)