+ Reply to Thread
Results 1 to 3 of 3

Excel Formula to Copy Value/ Words into a Cell if Amount is Equal to Another Cell Value

  1. 03-22-2017, 06:46 PM #1
    arnel_10
    arnel_10 is offline
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    Excel Formula to Copy Value/ Words into a Cell if Amount is Equal to Another Cell Value

    Hi Excel Experts,

    I am wondering if there could be someone who could help me create an excel formula that will copy a certain value or words from a range of cell if the amount is equal to the amount from another cell.

    I have attached the sample excel file I am working with to give you complete idea. Please let me know should you need any clarifications. Thanks!


    Warmest regards,
    Arnel
    Attached Files Attached Files
    Last edited by arnel_10; 03-22-2017 at 06:48 PM. Reason: Title Updated
    Reply With QuoteRegister To Reply
  2. 03-22-2017, 06:57 PM #2
    spitfireblue
    spitfireblue is offline
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Excel Formula to Copy Value/ Words into a Cell if Amount is Equal to Another Cell Valu

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.
    Reply With QuoteRegister To Reply
  3. 03-22-2017, 07:06 PM #3
    arnel_10
    arnel_10 is offline
    Registered User
    Join Date
    03-01-2017
    Location
    Manila, Philippines
    MS-Off Ver
    MS Office 2007
    Posts
    77

    Re: Excel Formula to Copy Value/ Words into a Cell if Amount is Equal to Another Cell Valu

    Hi Stephen,

    It works! Thanks for your immediate feedback. I really appreciate it much.


    Warmest regards,
    Arnel
    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. Copy a Cell if equal to a certain value - Excel VBA
    By beasley101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2015, 04:49 AM
  2. VLookup formula to copy value from certein cell, if two other cell data are equal
    By Robot3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-03-2014, 12:18 PM
  3. [SOLVED] formula to copy only capitalized WORDS from a cell
    By emymeeky in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-28-2013, 12:56 AM
  4. [SOLVED] formula if cell content doen not equal certain amount of characters
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2013, 11:19 AM
  5. How to make a single number equal a dollar amount in next cell?
    By mrphotoguy1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-05-2010, 06:11 PM
  6. Convert amount in cell to words
    By Raj Shah in forum Excel General
    Replies: 4
    Last Post: 04-19-2006, 07:06 AM
  7. make a letter in a cell automatically equal a dollar amount
    By kimzim in forum Excel General
    Replies: 1
    Last Post: 08-17-2005, 04:05 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