Results 1 to 19 of 19

Sumproduct formula needed (possibly using index/match)

Threaded View

  1. 04-02-2015, 06:40 PM #1
    bwmuhich
    bwmuhich is offline
    Registered User
    Join Date
    09-03-2013
    Location
    Elgin, IL
    MS-Off Ver
    Excel 2010
    Posts
    90

    Sumproduct formula needed (possibly using index/match)

    Hello Excel forum.

    I'm looking for a formula that will multiply the $ Amounts in C2-C14 by their correlating Benefit % in B17-B117 based on the ages of each person found in B2-B14.

    I'm looking for a formula that doesn't need any helper rows.

    Attached is the sample workbook.

    Thanking you in advance...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Need an array possibly INDEX/MATCH formula with multiple lookup criteria.
    By TheClaw2323 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2015, 09:59 AM
  2. Vlookup with index/match possibly.
    By Kramxel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2015, 06:06 AM
  3. Formula needed for partial string match as part of index match with multiple criteria
    By Marvelous in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  4. [SOLVED] Advanced Match Help (possibly Index Match)
    By dfxryanjr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2013, 09:13 AM
  5. Excel 2007 : SUM IF Across Range - Possibly Using Index / Match, Sumproduct or Hlookup?
    By kateWantstoLearn in forum Excel General
    Replies: 6
    Last Post: 01-03-2012, 07:36 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