Results 1 to 7 of 7

pick the corresponding Rate based on multiple selections and the term selected

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2015
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Office2007
    Posts
    47

    pick the corresponding Rate based on multiple selections and the term selected

    Dear Forum Expert,

    First of all thank you very much to give me the solution of my previous post using INDEX MATCH function.

    Yet again, here is another table on which I am working but unfortunately I was unable to get it done.

    On the updated sheet I need to pick the corresponding Rate based on multiple selections and the term selected. All the data is on one sheet called “GRID DATA”.

    Here is the example of a selection and what should be the result:

    Start Month: 15-AUG
    Zone: Houston Zone
    Profile: Low Load Profile
    Term Entered: 24
    Rate: 4.51₵
    The rate should be average of 24 rows Starting from 15-August (based on the start month selected), in Column ‘Houston Zone’ (the Zone selected), for the profile ‘Low Load Profile’ (the profile selected).

    Example 2:
    Start Month: 15-OCT
    Zone: Houston Zone
    Profile: High Load Profile
    Term Entered: 9
    Rate: 3.88₵
    The rate should be average of 9 rows Starting from 15-OCT (based on the start month selected), in Column ‘Houston Zone’ (the Zone selected), for the profile ‘High Load Profile’ (the profile selected).

    Awaiting feedback. Thanks and Regards.

    Sakib
    Attached Files Attached Files
    Last edited by sakib; 05-13-2015 at 11:22 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Function/Formula to take multiple entries from a table and combine data
    By officenoobtryinghard in forum Excel General
    Replies: 1
    Last Post: 02-14-2015, 12:41 PM
  2. How to use Formula and Function insetad of Pivot Table?
    By zhan_b1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-04-2014, 07:52 AM
  3. getting table name while writing formula using insert function
    By paramnayak in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-31-2013, 09:57 AM
  4. Replies: 3
    Last Post: 11-10-2005, 08:30 PM
  5. [SOLVED] Is there a help on the TABLE worksheet function in Excel?
    By Antoine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

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