+ Reply to Thread
Results 1 to 4 of 4

Index Match to populate a diary based on trainer availability

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    80

    Index Match to populate a diary based on trainer availability

    Hoping someone can help me with this. I suspect it is really easy but maybe I'm barking up the wrong tree.

    In Sheet 1 I have a list of dates for courses. In sheet 2 I have a list of trainers and their availability date. I am trying to populate sheet 1 using a formula such as Index / Match to look at the list of trainers on sheet 2, match their availabitiy date with a date on Sheet 1 and autofill their initials there. My stumbling block is that there are two trainers available each day so need to populate the Trainer 0815 -1630 Columns with a name... there is no preference which one goes in each time slot.

    I'm aware there are only two trainers per month so would probably be just as simple to type them in manually alongside their relevant date, but I want to use this as a learning excercise to try and understand better using formulas to populate cells.

    Cheers
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Index Match to populate a diary based on trainer availability

    You need to have similar date in both of the sheets !

    Find attached !

    formula used are array formulas you need to confirm them using control shift and enter instead of pressing simply enter!
    Attached Files Attached Files
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Registered User
    Join Date
    10-29-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Index Match to populate a diary based on trainer availability

    Wow that is one terrifying formula and probably overkill using a sledgehammer to crack an eggshell. However it gives me an opportunity to pick apart the formula to try and understand how it works.
    Many thanks for your time and expertise.

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Index Match to populate a diary based on trainer availability

    Thanks for the Feedback and Rep !

+ 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/Populate data based on key value
    By mzafar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2013, 01:49 PM
  2. Replies: 8
    Last Post: 12-18-2012, 05:18 AM
  3. Index, Match and populate data
    By danmar7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2010, 03:19 PM
  4. Populate listbox using vlookup or index,match?
    By sarahng86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2007, 08:42 AM
  5. INDEX/MATCH formula in VBA to populate text boxes
    By Amber_D_Laws in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-17-2006, 12:19 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