Formulae to pick data from different sheets
I wanted solution for this problem where I had some currency in one data sheet and the exchange rates in the other. How can we plug a formula that picks the exchange rates from that sheet and converts it into required currency.
Ex: Converting 100 Euros, 20 INR, 40 GBP all in one sheet to USD.