Hi,
I am looking for help with formula for copy values from reference cells and paste to cell containing this formula based on words in another cell, For example (attached a screen shot of excel sheet) if A10 is "USD", then cell B10 should have the value from cell D4. Like wise if A10 is "EUR" then cell B10 should have the Value from cell D5.
If someone could point me in the right direction to learn how to do this it would be greatly appreciated.
Thank You,
Francis
Excel ss.PNG
Bookmarks