+ Reply to Thread
Results 1 to 5 of 5

Match/Index maybe? Formula to pull a cell in column A based on a match for two columns

  1. #1
    Forum Contributor
    Join Date
    10-13-2015
    Location
    California
    MS-Off Ver
    Office 2013
    Posts
    138

    Match/Index maybe? Formula to pull a cell in column A based on a match for two columns

    Hello,


    I have a sheet where I am tracking labor based on another sheet where the labor is exported.

    What I am trying to do is pull the date from the labor sheet that matches the order AND the task.

    On the labor sheet the Date in column A. The order # in in Column I and the task is in Column M

    It looks like this.

    Date BlahBlah BlahBlah BlahBlah BlahBlah BlahBlah BlahBlah BlahBlah Order BlahBlah BlahBlah BlahBlah Task
    4/13/2017 ABCD General Production Tasks

    On my main sheet i have all the tasks possible in the header so for example.

    Order # is in column A, in this case lets say ABCD is A2

    General Production tasks is in my header as B1

    In B2 I would like a formula to check my labor sheet and match the order # A2 with the task B2 and return the date that it was completed on. The end result here would be 4/13/2017.

    I can upload a sample workbook if needed but i feel like this is probably an easy formula and i am just messing something up.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,704

    Re: Match/Index maybe? Formula to pull a cell in column A based on a match for two columns

    I don't think the description matches ... the description. I also have to imagine (guess) too much.

    On the labor sheet the Date in column A. The order # in in Column I and the task is in Column M
    Order # is in column A, in this case lets say ABCD is A2
    Please upload a small example of what you are working with, the output desired (hand typed if necessary) and a brief explanation of the logic ... why the output is what it is.
    Dave

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    28,829

    Re: Match/Index maybe? Formula to pull a cell in column A based on a match for two columns

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    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



  4. #4
    Forum Contributor
    Join Date
    10-13-2015
    Location
    California
    MS-Off Ver
    Office 2013
    Posts
    138

    Re: Match/Index maybe? Formula to pull a cell in column A based on a match for two columns

    Attached is a small sample.
    Attached Files Attached Files

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Match/Index maybe? Formula to pull a cell in column A based on a match for two columns

    There are many ways that you can use. One is this array formula ( hold down CTRL + SHIFT then hit Enter Key )
    In Master Tab B2

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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: 2
    Last Post: 09-18-2015, 02:39 AM
  2. [SOLVED] index match formula won't fill across columns or adjust if column is deleted
    By duvius in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2015, 11:57 AM
  3. [SOLVED] Formula to change column ref based on date and do index match
    By Marq555 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-25-2014, 08:01 PM
  4. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  5. Using the INDEX and MATCH Formula to pull costs.
    By AntP_ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2014, 08:09 AM
  6. Replies: 6
    Last Post: 04-12-2013, 05:50 AM
  7. Replies: 6
    Last Post: 12-10-2012, 06:26 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