+ Reply to Thread
Results 1 to 2 of 2

Really difficult formula needed (Not sure if its possible) help if you can please

  1. 06-18-2013, 12:17 AM #1
    Petefav
    Petefav is offline
    Registered User
    Join Date
    06-17-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    19

    Wink Really difficult formula needed (Not sure if its possible) help if you can please

    I have two worksheets. Worksheet 1 is called FX and worksheet 2 is called Converted Price.

    FX has a list of dates in column A1:A1000 in the following format dd/mm/yyyy i.e 01/01/2011 and exchange rates in Column B1:B1000 i.e 0.87

    Converted Price Column A1:A1000 contains dates in the same format as FX (dd/mm/yyyy i.e 01/01/2011) and Column B1:1000 has an amount i.e $19,944.30.

    I need a formula in Converted Price C1:C1000 that will search and match the same date in Converted Price A1:A1000 and FX A1:A1000, If matched then multiply the number in Converted Price B1:B1000 by the exchange rate number in FX Column B1:B1000 and display answer in C1:C1000

    Is this possible? If so what is the formula?

    If this is not possible is there another way of achieving the result I need?

    Many thank in advance
    Reply With QuoteRegister To Reply
  2. 06-18-2013, 12:23 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,936

    Re: Really difficult formula needed (Not sure if its possible) help if you can please

    Hi and welcome to the forum

    We would love to help you with your question, but 1st, in accordance with forum rules, please rename your thread to something more meaningful, that actually describes your problem.

    Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

    Many members will look at a thread title, and if it is of interest to them, or it falls within their area of expertise, they might only open those threads.

    Look at it this way...if you typed that title into google, what would you expect to get back?

    To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
    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
+ 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)

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