Another "vLookup" Question

[daveyc3000]

so in my "DATA" file, i have a currency column (column A); any row with "U$", the MV needs to be multiplied by the "Close" rate shown in the "FX" file ( that is, the rate shown in cell I10).

probably simple to do, but im a newb

[daveyc3000]

Sorry I dont understand when I tried to make the "C$" rate = 1 , Alteryx makes it 0????