VLOOKUP to Convert Currencies

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.

Try in C2 and copy down

Formula:

Please Login or Register  to view this content.

Originally Posted by José Augusto

Try in C2 and copy down

Formula:

Please Login or Register  to view this content.

Works perfect. Thank you.

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.