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

[BRRLL99]

this is your expected output?

Close Rate	Currency	MV	cal
1.2727	U$	31231	39747.69
1.2727	U$	1232	1567.97
1.2727		12	0
1.2727		31	0
1.2727		3212	0
1.2727		41567	0

[daveyc3000]

thank you...almost...currency not blank is to left alone (or multiplied by 1 if that makes it easier)

[BRRLL99]

Close Rate	Currency	MV	cal
1.2727	U$	31231	39747.69
1.2727	U$	1232	1567.97
1.2727	1	12	0
1.2727	1	31	0
1.2727	1	3212	0
1.2727	1	41567	0

Next please make sure to input and expected output also

[daveyc3000]

my apologies, im obviously not being clear...under the "cal" column, the rows with blank currency (they should be left blank or ideally replaced with "C$", but if that's too much to ask, leave as blank), the values should be still be 12,31,3212, and 41567 , not 0  ....they are native currency so the numbers should not change

[BRRLL99]

this is your output requirement?

Close Rate	Currency	MV	cal
1.2727	U$	31231	39747.69
1.2727	U$	1232	1567.97
1.2727	C$	12	0
1.2727	C$	31	0
1.2727	C$	3212	0
1.2727	C$	41567	0

[daveyc3000]

im back on my desktop...pls see attached what i desire

output from F to G is a nice to have (ie "C$" instead of blanks), but not needed

[BRRLL99]

Step: 1

For FX file 

Apply filer CLOSE: on F7 column

step: 2

Select tool to remove unwanted columns

step:3

Add formula tool, and create dummy column with 1 in it ( this is created to join both FX file and Data file)

For data file

Add formula tool and create 3 new columns

1. Dummy : 1

2. remove commas

3. Currency :

 IF IsNull([Currency])
THEN "C$"
ELSE [Currency]
ENDIF

After join based on dummy column
Add formula tool

create new column cal

with this formula

if Contains([Currency], "U$")
then [Close Rate] * [MV]
else [MV] *1
endif

[prakharalteryx]

Please see the attached workflow for the solution. Kindly note this is for case where we are picking value directly from the cell specified (I10).  

[daveyc3000]

thanks for the flow, but I need the MV for "U$" currency to multipled by the rate/number shown in the FX file, cell i10 (or alteryx, column F9, record 9)