Results 1 to 7 of 7

Finding a specific word in a cell and executing an array

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2009
    Location
    NH
    MS-Off Ver
    Excel 2003
    Posts
    18

    Finding a specific word in a cell and executing an array

    I hope the title explains ok.

    I am playing with my sheet some more and basically I have a "list" of items to choose from in H5:H34.

    List Contains below:
    Full - CASH
    Full - CHECK
    Full - VISA
    Full - MC.
    Full - Disc.
    Full - Amex
    Balance - CASH
    Balance - CHECK
    Balance - VISA
    Balance - MC
    Balance - DISC.
    Balance - AMEX
    Deposit - CASH
    Deposit - CHECK
    Deposit - VISA
    Deposit - MC
    Deposit - DISC.
    Deposit - AMEX
    Refund
    Quote


    I want an array formula that I can use that will allow excel to search for the word "cash" (Or VISA,CHECK,MC, etc..) in column H5:H34 which will have other words such as (Balance, Deposit, Full, etc. ) in the same cell and then add up some dollar amounts in column J5:J34.

    My code right now that I was trying which has failed. (This code is in the Cash cell which adds up all dollar amounts put in with cash)
    =SUM(IF(H5:H34="",,(IF(H5:H34="quote",,IF(H5:H34="refund - cash",IF(MATCH(H5:H34="cash",-J5:J34)),IF(MATCH(H5:H34="cash",J5:J34)))))))
    This portion is what I really need
    IF(MATCH(H5:H34="cash",-J5:J34)),IF(MATCH(H5:H34="cash",J5:J34))

    MATCH I believe is the wrong thing to use as I read it only gives you a "position" of where something is.
    Last edited by jgray152; 01-09-2010 at 05:34 PM.

Thread Information

Users Browsing this Thread

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

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