Results 1 to 4 of 4

Index Matching multiple variables (SELECT date FROM table WHERE serial = x AND step = y)

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2019
    Location
    California
    MS-Off Ver
    Office Pro 2016
    Posts
    13

    Index Matching multiple variables (SELECT date FROM table WHERE serial = x AND step = y)

    I am trying to do an index match where I can filter out the data by 2 variables instead of one. Since each serial number has multiple entries, I want to do something like this for anyone that knows MySQL SELECT date FROM table WHERE serial = x AND step = y

    With one MATCH function it just repeats the first date. So I tried adding 2 MATCH() functions but it breaks:
    Capture.JPG

    I've also attached an excel file (see attached). Any ideas?
    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] Formula required to copy values in a Matrix as step down according to serial number
    By sameer79 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-12-2019, 02:02 PM
  2. Matching Data Across Sheets on Serial ID & Date
    By Rik05 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2019, 07:39 AM
  3. Select multiple multiple cells adjacent to a date and populate a table
    By fedeboja in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-21-2018, 05:51 PM
  4. Matching 3 variables for histogram table
    By dragosalaamii in forum Excel General
    Replies: 5
    Last Post: 06-15-2017, 04:02 PM
  5. [SOLVED] Lookup or index on multiple parameters and pull table heading for matching values
    By pcrewlok in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-24-2015, 07:07 PM
  6. Replies: 4
    Last Post: 05-06-2013, 11:06 AM
  7. Can anyone give me a step by step procedure on date expirations with color
    By Gracieline in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2012, 08:35 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