VLOOKUP giving wrong results

[boddulus]

Test.xlsxHi Guys i am new to excel, I had tried many formulas but it is not working .It is always giving me the same result.for formulas which i used u can refer to the attached .please correct them or u can given me a new formula which can work out. please guys help me out .thanks in advance.
what i want is
"Taking the base reference of Crncy column in sheet1 i want every cusip in sheet 2 to under go the formulas in sheet one concatenate column for example it the curncy in sheet 1 is USD then it should undergo USD formula in sheet1 and i should get the result in sheet 2 in current price column.

I have tried some formulas but they are not at all working. please refer the attachment i one i have highlighted in sheet 2 with red are wrong one . if you compare them with cusip column in same sheet they doesn't match each other.