Results 1 to 4 of 4

Index & Match a table of data using multiple parameters

Threaded View

monaghanmj44 Index & Match a table of data... 11-20-2013, 10:12 PM
FDibbins Re: Index & Match a table of... 11-20-2013, 10:53 PM
sktneer Re: Index & Match a table of... 11-20-2013, 11:00 PM
azumi Re: Index & Match a table of... 11-21-2013, 01:29 AM
  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Index & Match a table of data using multiple parameters

    Hi,

    First time on this forum. I desperately need help with the following issue.
    Cannot figure out how to match parameters based on more than one cell on a data sheet and lookup the instersecting result in a table another sheet (Sheet2).

    There are 3 lookup parameters in this particular case. 2 cells cover a business name and business unit which need to match with first 2 rows of cells in the Sheet2!table followed by the corresponding business 'status' which can alter from month to month. There is 60 months of current and historical Business/Unit status in the table.

    The third parameter cell is a month/year date (e.g. Sep13) which can be manually altered and matches with the column headings in the Sheet2 table.

    I have provided an example.xlxs attachment which I hope makes more sense.
    I have a had a few goes with Index and Match but just cannot get a handle on this.

    Any help would be very grateful

    Thanks
    MJM
    Attached Files Attached Files

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 table using two columns of data
    By purdue7997 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2013, 08:25 AM
  2. Data table based on user selection and index/match
    By pauldaddyadams in forum Excel General
    Replies: 0
    Last Post: 10-19-2012, 07:58 AM
  3. [SOLVED] Using LOOKUP, MATCH, INDEX to obtain cell value from data table
    By rfernandes in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-05-2012, 05:31 PM
  4. [SOLVED] Problem with INDEX, MATCH, and a function to count data from a table
    By Pentasyllabic in forum Excel General
    Replies: 10
    Last Post: 05-22-2012, 05:16 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1