+ Reply to Thread
Results 1 to 4 of 4

index match from multiple columns

  1. #1
    Forum Contributor
    Join Date
    04-29-2012
    Location
    nuneaton, England
    MS-Off Ver
    Excel 2007
    Posts
    366

    index match from multiple columns

    I have an annual leave spreadsheet that i fill out... ie

    05/01/2019 - 12/05/2019 (this is over 3 cells) and want to put it into a calendar. See image.

    basically i want to use a conditional format that highlights the cell to show the annual leave.

    what i have done so far is to split the dates (so in the above scenario it will show all dates between the dates supplied) and then the calendar part highlights those days

    I know index match doesnt allow for multiple columns, but how can i address my situation. Need to convert Sect 1 to Section 3 (which is just the highlights) and at the moment, my isnumber/match is only one column.


    wayne
    Attached Images Attached Images

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: index match from multiple columns

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Contributor
    Join Date
    04-29-2012
    Location
    nuneaton, England
    MS-Off Ver
    Excel 2007
    Posts
    366

    Re: index match from multiple columns

    Here is the sample page
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    04-29-2012
    Location
    nuneaton, England
    MS-Off Ver
    Excel 2007
    Posts
    366

    Re: index match from multiple columns

    Doesnt matter... i have added 5 conditional formats using 1 column at a time.

    thanks anyway

    wayne

+ 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. Index Match across multiple columns
    By cfitz97 in forum Excel General
    Replies: 2
    Last Post: 06-15-2018, 08:53 PM
  2. [SOLVED] Index match to sum multiple match columns
    By rosboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2018, 04:14 PM
  3. Match/Index Multiple Columns
    By fredlo2010 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-15-2018, 03:43 AM
  4. Match Index multiple columns
    By jewbsur0 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-19-2016, 10:15 AM
  5. INDEX MATCH MATCH multiple columns with same heading
    By djm198 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2016, 02:34 PM
  6. Index Match multiple columns
    By Kdjonesmtb in forum Excel General
    Replies: 1
    Last Post: 11-29-2014, 11:45 AM
  7. Index Match Across Multiple Columns
    By FFastZB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-20-2013, 04:58 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