Results 1 to 4 of 4

VLOOKUP to Convert Currencies

Threaded View

ramridd VLOOKUP to Convert Currencies 12-05-2018, 10:56 AM
José Augusto Re: VLOOKUP to Convert... 12-05-2018, 11:00 AM
ramridd Re: VLOOKUP to Convert... 12-05-2018, 12:01 PM
José Augusto Re: VLOOKUP to Convert... 12-05-2018, 12:33 PM
  1. 12-05-2018, 10:56 AM #1
    ramridd is offline
    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
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. How to sum value with different currencies & convert these resuls into one currency only?
    By PHUONG TRAN in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1