+ Reply to Thread
Results 1 to 6 of 6

Copy Values From Reference Cells Based On Words Of Another Cell

  1. #1
    Registered User
    Join Date
    03-31-2016
    Location
    India
    MS-Off Ver
    2007
    Posts
    3

    Copy Values From Reference Cells Based On Words Of Another Cell

    Hi,

    I am looking for help with formula for copy values from reference cells and paste to cell containing this formula based on words in another cell, For example (attached a screen shot of excel sheet) if A10 is "USD", then cell B10 should have the value from cell D4. Like wise if A10 is "EUR" then cell B10 should have the Value from cell D5.

    If someone could point me in the right direction to learn how to do this it would be greatly appreciated.

    Thank You,

    Francis
    Excel ss.PNG

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Copy Values From Reference Cells Based On Words Of Another Cell

    B10:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and drag down

  3. #3
    Registered User
    Join Date
    03-31-2016
    Location
    India
    MS-Off Ver
    2007
    Posts
    3

    Re: Copy Values From Reference Cells Based On Words Of Another Cell

    Hi Sandy,

    Many thanks for quick response. Yes it worked for me like a charm.

  4. #4
    Registered User
    Join Date
    03-31-2016
    Location
    India
    MS-Off Ver
    2007
    Posts
    3

    Re: Copy Values From Reference Cells Based On Words Of Another Cell

    Quote Originally Posted by Francis Tom View Post
    Hi Sandy,

    Many thanks for quick response. Yes it worked for me like a charm.
    However I would like to know is there any other way like just getting the info from a particular cell instead of looking for a range of cell.

    Regards,

    Francis

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Copy Values From Reference Cells Based On Words Of Another Cell

    Glad to help

    If problem is resolved, add star and mark thread as solved. Thank you.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Copy Values From Reference Cells Based On Words Of Another Cell

    You can use INDEX() and MATCh() but it is similar to VLOOKUP() like:
    in B10:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and drag down
    Last edited by sandy666; 03-31-2016 at 06:44 AM. Reason: formula added

+ 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. Replies: 2
    Last Post: 02-06-2016, 10:19 AM
  2. Copy based on Relative Cell Reference and paste to Fixed cells
    By CDNcameron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2014, 04:40 PM
  3. [SOLVED] Copy and Paste Range of Cells based on # of cell values in Column A
    By bwaite87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2014, 05:51 PM
  4. [SOLVED] copy cell values in one cell based on value of adjacent cells
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2014, 08:48 AM
  5. Copy cells based on multiple cell values
    By Richard Brook in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2013, 09:58 AM
  6. [SOLVED] Macro - Copy and Combine values in cell and paste it in other cells based on Unique ID
    By haleakala17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2012, 05:41 PM
  7. Replies: 2
    Last Post: 05-30-2012, 05:02 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