+ Reply to Thread
Results 1 to 4 of 4

need to get help on a match function

  1. #1
    Registered User
    Join Date
    03-06-2015
    Location
    india
    MS-Off Ver
    2010
    Posts
    1

    need to get help on a match function

    hi all
    want help on a data where i am trying to derive values from cells alligned to a perticular row. the vlookup wont help here as it will need to horizontally look up from the dates and the if formula is too lengthy. please suggest what can be used.
    Attached Files Attached Files

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: need to get help on a match function

    Use
    =INDEX($B$3:$J$7,MATCH($A12,$A$3:$A$7,0),MATCH(B$11,$B$2:$J$2,0))
    in B12 and copy across and down till wherever required..
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Registered User
    Join Date
    03-02-2015
    Location
    Kent
    MS-Off Ver
    2010
    Posts
    11

    Re: need to get help on a match function

    I need help please with a match formula.

    =IF(MATCH(A3,Sheet2!$A$3:$A$1000,0),"Sheet2",IF(MATCH(A3,Sheet3!$A$3:$A$1000,0),"Sheet3",IF(MATCH(A3,Sheet3!$A$3:$A$1000,0),"Sheet4",FALSE)))

    I can't get the match to work for sheet3 and sheet4, what I'm trying to do is lookup the list of employees on the main sheet against what sheet2/3/4 has if sheet2/3/4 has less employees I need to easily identify who's missing.

  4. #4
    Registered User
    Join Date
    12-18-2014
    Location
    Asyut,Egypt
    MS-Off Ver
    365
    Posts
    8

    Re: need to get help on a match function

    data req (Solution).xlsx

    You will find the formula on the attached file

+ 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] Vlookup to Pivot Table, using Match function, returns error if can't find match value
    By AndrewHowarth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2015, 12:10 AM
  2. [SOLVED] Stuck on Match function with #N/A; attempting to reverse Index/Match
    By Cappytano in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2014, 06:39 PM
  3. INSERT/MATCH Function - can I match and return more than a single result?
    By nickwee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2014, 06:02 AM
  4. Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  5. Replies: 5
    Last Post: 10-26-2012, 02:21 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