I'm currently working with a worksheet that has multiple currencies that will need to be converted to USD. I've attached a small example of this.
I'm looking to have the vlookup formula in cell C2 on sheet1.
How can I reference the table in sheet 2 to apply the conversion rates?
Please help. Thank you.
Bookmarks