Results 1 to 4 of 4

If one column has a specific phrase then display value from another column in the same row

Threaded View

kkihead If one column has a specific... 10-24-2013, 04:20 PM
vamosj Re: If one column has a... 10-24-2013, 04:31 PM
kkihead Re: If one column has a... 10-24-2013, 04:36 PM
vamosj Re: If one column has a... 10-24-2013, 05:05 PM
  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    michigan, USA
    MS-Off Ver
    Excel 2010
    Posts
    20

    If one column has a specific phrase then display value from another column in the same row

    Hi everyone,
    I am working on creating an expense report. I would like to set up a formula that checks to see if a specific word or phrase is in one column and if so then it will display the amount in the correct column.
    In columns H and I, I would like for it to check column G for the payment method. If the payment type is Cash or Personal Credit Card I would like it to display the $ Amount from the same row in Column D in Column I (Expense reimburse total). If the payment type is Company Credit Card I would like it to display the $ Amount from the same row in Column D in Column H (Company CC total).
    The worksheet is attached.
    Thank you in advance,
    Nikki
    Attached Files Attached Files
    Last edited by kkihead; 10-25-2013 at 08:15 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-02-2013, 08:26 PM
  2. command to display specific rows based on value in one column
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2013, 07:28 AM
  3. [SOLVED] Search for a phrase in a column Error !Value
    By bh06als in forum Excel General
    Replies: 5
    Last Post: 02-18-2013, 10:16 AM
  4. Have a column return a phrase based on a number in another column
    By luke.guthrie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2012, 04:04 PM
  5. Extracting word from phrase within column
    By KH_GS in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 04-03-2006, 09:50 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