How to use switch


I have two excel files, one contains currency rates and the other file contains the total price in different currency.

I will have to split the code and price from the Total Price column in Excel 1 and based on the currency code, I have to multiply the Total Price (excel 1) and the currency rates from the 2nd excel.

I have achieved the splitting of total price column from excel 1, now how to get the respective currency rates from excel 2 ?

PFB screenshot of both files


Hi @Aishwarya ,

You can try these:

  • Splitting the Currency Unit value in table 1 into a separate column.
  • Then, use join data table, compare that unit column value with the unit column in table 2
  • After that, you will be able to match that rate into a column in table 1
1 Like

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.