This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'd recommend using the Find and Replace tool and use the Append option in its configuration (rather than the Replace) to be able to append the relevant exchange rate that you pull from your 'lookup table' to your master table. Then use the Formula tool for the calculation.