Results 1 to 1 of 1

Thread: Lookup Multi-Column For Unique String Combination For Numeric Value Output

  1. #1
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10

    Lightbulb Lookup Multi-Column For Unique String Combination For Numeric Value Output

    Here's a way to look up multiple columns for a unique combination of values, where the resultant value is a unique numeric value. The formula used is a sumproduct of the text columns, and a single numeric column

    =SUMPRODUCT(--(CombinationList!$A$2:$A$71=Display!$D$2),--(CombinationList!$B$2:$B$71=Display!$G$2),--(CombinationList!$C$2:$C$71=Display!$J$2),Combinat ionList!$D$2:$D$71)
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 10
    Last Post: 05-23-2013, 12:30 PM
  2. Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  3. Replies: 16
    Last Post: 04-19-2013, 08:20 PM
  4. Lookup From Cell Range By Matching Row and Column
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 03-07-2013, 02:02 PM
  5. Remove only numeric value in the end of any string
    By LalitPandey87 in forum Excel Help
    Replies: 3
    Last Post: 04-08-2012, 09:39 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •