+ Reply to Thread
Results 1 to 4 of 4

How to use INDEX formula to output a cross section of data

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    20

    How to use INDEX formula to output a cross section of data

    Hello,

    I'm hoping you can please assist with the below problem that I'm having:

    Essentially, as per the attached spreadsheet I have a row of clients who have associated discounts for certain publications. I would like to have a Data Validation list (B2) which chooses from these publications (D2:DF). When the user chooses a publication in B2 I would like the respective discount to appear in the cell next to the client's name (B3:B15).

    The Cell I am currently attempting to use is below:
    =INDEX(D3:F15,MATCH($B$2,$D$2:$F$2,0))

    Any help would be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: How to use INDEX formula to output a cross section of data

    Just replaced the comma with double comma to move the match function from RowNumber to ColumnNumber

    =INDEX($D$3:$F$15,,MATCH($B$2,$D$2:$F$2,0))


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-08-2014
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: How to use INDEX formula to output a cross section of data

    That worked perfectly thank you

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,341

    Re: How to use INDEX formula to output a cross section of data

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index Match Formula doesn't recognize output from Right Formula as lookup value.
    By GoGators in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2015, 11:33 AM
  2. convert data from cross section to panel format
    By diquez in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2012, 12:58 PM
  3. Make panel structure data from cross section
    By jhound in forum Excel General
    Replies: 5
    Last Post: 11-11-2011, 12:36 AM
  4. How do I create a cross section between two columns?
    By Yasko in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2006, 11:15 AM
  5. Calculate areas from a cross section chart??
    By nated7777 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2006, 11:00 AM

Tags for this Thread

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