Using vlookup for multiplication

[banneduser123]

Ok two I have two files


File 1
Column A Column B
Currency FX Rate
USD 1.14
EUR 1
JPY 126.77




File 2
Column F Column G Column K
Local Currency Local Amount Euro Equivalent
USD 5
EUR 10
JPY 8



Hopefully the above will come out looking ok...

So what I want is for Column K to have a formula, where it'll look for the currency from column F in column A, and then take its respective Rate from column B, and multiply it against what's in column G.

Any help is appreciated

 

[duggie33]

In K2… =vlookup(File2-F2,File1-ColA:ColB-Range,2,false)*File2-G2

Hopefully that makes sense,

Doug

 

[banneduser123]

perfect..thanks so much doug

 

[duggie33]

You are welcome.