+ Reply to Thread
Results 1 to 5 of 5

Index / match formula to look up first and last data entry in a row and return values

  1. #1
    Registered User
    Join Date
    02-13-2018
    Location
    Midlands
    MS-Off Ver
    2016 Business
    Posts
    6

    Index / match formula to look up first and last data entry in a row and return values

    Good morning everybody,

    I am hoping someone may be able to help write a formula to solve the following problem. I am pretty sure it is a matched index formula, but i cant seem to find one online to help me figure it out, so i am looking to one of you to provide a solution.

    It is easiest to explain the formula i am after in the 2 tables below.

    What i am trying to do is write a formula for column B (Start Date) and Column C (End Date) that looks up the first and last data entry for each of the companies and returns the corresponding month...

    It should look like the second table of the two below.


    Can anyone help?

    Thanks in advance
    Attached Images Attached Images
    Last edited by Coopereto; 02-13-2018 at 07:36 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,043

    Re: Index / match formula to look up first and last data entry in a row and return values

    Rather than attach a picture, which we can't work with, it would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Please note that the Paperclip icon (Attachments button) does not work on this forum, so don't try to use that.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    02-13-2018
    Location
    Midlands
    MS-Off Ver
    2016 Business
    Posts
    6

    Re: Index / match formula to look up first and last data entry in a row and return values

    Hi Pete,

    I have managed to solve the problem, but thanks for advising on the best way to upload documents for review. I was pulling my hair out yesterday trying to append a table to make sense, so thanks for the help in future.

  4. #4
    Registered User
    Join Date
    02-14-2018
    Location
    UK
    MS-Off Ver
    Office 15
    Posts
    3

    Re: Index / match formula to look up first and last data entry in a row and return values

    Do you mind telling me how you solved this one?

    I need to find the first non-blank column in a row of data and then return the value in row 1. The Index, Match seems to return the last value

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,402

    Re: Index / match formula to look up first and last data entry in a row and return values

    Start your own thread (this one is effectively solved/closed), attach a small sample spreadsheet (10-20 rows of data) and you'll have an answer in minutes...

    Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



+ 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. Replies: 1
    Last Post: 06-13-2017, 01:21 PM
  2. [SOLVED] Using INDEX MATCH formula to return values that will skip blank cells
    By mark_luke in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2017, 06:11 PM
  3. [SOLVED] Help with an Index Match formula so that it return values in order (dates)
    By michelle 1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-23-2016, 11:40 AM
  4. Replies: 2
    Last Post: 05-27-2015, 12:45 AM
  5. [SOLVED] Need Help Creating INDEX/MATCH Formula to Return Values from Data Table
    By trandle in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-06-2015, 01:12 PM
  6. Replies: 2
    Last Post: 02-20-2015, 05:23 PM
  7. [SOLVED] Formula (VLOOKUP vs INDEX & MATCH) to return multiple values in the same column
    By wfidler in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2012, 07:04 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