Forum Discussion

Hamdan1234's avatar
Hamdan1234
Icon for Helper III rankHelper III
4 years ago

Excel Formula Replication

I have got two tables in two sheets  and I have used Sumifs formula in excel to get a new column on the basis of both the tables.Tables are: Month Curr Conversion Rate Jan AUD 0.769823 ...
Need Help
manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
4 years ago

Hamdan1234 ,
Create relationship on currency type and use RELATED or LOOKUPVALUE to get the value.