+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP to Convert Currencies

  1. #1
    Registered User
    Join Date
    08-01-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    20

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: VLOOKUP to Convert Currencies

    Try in C2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-01-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    20

    Re: VLOOKUP to Convert Currencies

    Quote Originally Posted by José Augusto View Post
    Try in C2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Works perfect. Thank you.

  4. #4
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: VLOOKUP to Convert Currencies

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to convert multiple currencies in a column
    By HaramiPollins in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2018, 10:17 AM
  2. Convert Currencies and adjust by rates
    By MinisoftEggshell in forum Excel General
    Replies: 7
    Last Post: 05-07-2017, 07:48 PM
  3. Convert values with different currencies, from different years to EUR
    By Copiloc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2016, 08:31 AM
  4. [SOLVED] add different currencies
    By engmhelmy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-07-2015, 01:43 PM
  5. [SOLVED] Need Help : SUM Different Currencies
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2015, 11:33 AM
  6. [SOLVED] Help - How to convert multiple currencies with one VBA
    By indik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2015, 01:33 PM
  7. Replies: 7
    Last Post: 06-15-2014, 10:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1