+ Reply to Thread
Results 1 to 3 of 3

Vlookup Formula to update multiple exchange rates for multiple products

  1. 10-23-2016, 11:38 PM #1
    jocpatch
    jocpatch is offline
    Registered User
    Join Date
    04-20-2016
    Location
    Perth Western Australia
    MS-Off Ver
    2013
    Posts
    5

    Vlookup Formula to update multiple exchange rates for multiple products

    Hi, I'm looking for assistance in creating a formula to update a sheet with multiple products with multiple exchange rates.

    I'd like to bulk update prices when exchange rates change. If I apply the exchange rate against the AUD amount, all the prices with the other currencies, need to be updated at once.

    I had a vlookup formula previously, it went something like this. =ROUND(SUMIFS($H:$H, $D:$D, ÄUD", $G:$G,4G645)*VLOOKUP(D645.dATA!$A2:$B$15,2,FALSE),0), but it's stopped working.
    EXL Forum sample.PNG

    I appreciate any help at all,

    thanks
    Jocpatch
    Reply With QuoteRegister To Reply
  2. 10-24-2016, 02:26 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Vlookup Formula to update multiple exchange rates for multiple products

    Hi, welcome to the forum

    A formula doesnt just "stop working", something must either have changed in the data that it uses, or the formula was changed, to cause it to not be able to perform now - do you have any idea what that might be?

    Without seeing what your formula is referencing, it would be hard to say what the problem might be, but it essentially made up of 2 parts...
    SUMIFS($H:$H, $D:$D, ÄUD", $G:$G,4G645)
    and
    VLOOKUP(D645.dATA!$A2:$B$15,2,FALSE),0),
    For the SUMIFS...
    the data to sum is in H?
    Based on yoyr sample pic, your Code is in D, yet you are looking in D?
    Cannot see G, so no idea what that might be, but what would "4G645" be? Should that be D645, as in the vlookup?

    run the 2 calcs on their own and see what each genetates - are they producing as expected? Is there an error?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 10-24-2016, 08:36 PM #3
    jocpatch
    jocpatch is offline
    Registered User
    Join Date
    04-20-2016
    Location
    Perth Western Australia
    MS-Off Ver
    2013
    Posts
    5

    Re: Vlookup Formula to update multiple exchange rates for multiple products

    HI Ford, thanks for getting back to me so quickly!
    I managed to ask a colleague for assistance: there were three linked worksheets, and I probably didn't explain myself well in the first question.
    Cheers
    Jocpatch
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Counting products based on Invoice Number and Multiple Products on same column
    By a1mobile in forum Office 365
    Replies: 8
    Last Post: 07-01-2016, 02:07 AM
  2. VBA Function - Exchange Rates
    By skankingpigeon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2016, 06:53 PM
  3. [SOLVED] Foreign Exchange rates, auto update
    By Geoffo123 in forum Excel General
    Replies: 1
    Last Post: 03-02-2015, 06:13 PM
  4. Exchange rates display
    By akhmoud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2013, 02:02 AM
  5. [SOLVED] Update exchange rates in Excel with the content from the Internet
    By Even in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2013, 08:41 AM
  6. [SOLVED] Calculating multiple exchange rates
    By Merlinti in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-20-2012, 03:42 PM
  7. Formula for exchange rates
    By msincome in forum Excel General
    Replies: 1
    Last Post: 03-29-2011, 03:14 AM

Tags for this Thread

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