Results 1 to 6 of 6

Re-ordering data using MATCH and INDEX with multiple criteria

Threaded View

REV18 Re-ordering data using MATCH... 06-02-2018, 11:30 PM
JieJenn Re: Re-ordering data using... 06-02-2018, 11:50 PM
sandy666 Re: Re-ordering data using... 06-02-2018, 11:54 PM
sandy666 Re: Re-ordering data using... 06-03-2018, 12:10 AM
REV18 Re: Re-ordering data using... 06-03-2018, 04:31 AM
sandy666 Re: Re-ordering data using... 06-03-2018, 04:35 AM
  1. #1
    Registered User
    Join Date
    01-26-2018
    Location
    Melbourne
    MS-Off Ver
    Excel 2016
    Posts
    13

    Red face Re-ordering data using MATCH and INDEX with multiple criteria

    Hi,

    I was hoping to get some advice/suggestions.

    Referring to the attached spreadsheet, I have data ('data' sheet) in multiple columns.

    I would like to retrieve 'PV' (column H) from the 'data' sheet and re-order it where:
    -'param_ID'= O3
    -'SP_name'= separate columns
    -date/time in separate rows

    I constructed an index match array formula to apply these multiple criteria and retrieve the 'PV' data accordingly, however it returns an error at the moment.

    Any suggestions would be greatly appreciated.

    THanks
    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. VBA Code for Index Match (multiple criteria) on Customer Data Sheet - Data Enrichment
    By JPaint005 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2017, 10:05 AM
  2. [SOLVED] Multiple Criteria lookup to extract data from a dump - INDEX MATCH????
    By Rossovich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2016, 01:14 PM
  3. [SOLVED] Index Match with multiple criteria - Return top sellers for certain week from year data
    By albanhac in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2016, 06:28 AM
  4. [SOLVED] Index Match with multiple criteria and selecting data from a large table
    By Aquarock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2014, 09:26 PM
  5. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  6. [SOLVED] INDEX, MATCH: multiple criteria with iterative data
    By boai in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-05-2013, 06:43 AM
  7. Replies: 5
    Last Post: 01-05-2011, 03:13 PM

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