+ Reply to Thread
Results 1 to 5 of 5

index match give wrong cell TRIED EVERYTHING !

  1. #1
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    index match give wrong cell TRIED EVERYTHING !

    hi i am already 1 hour I can't find

    I did already many index matches , and know how t must be built but

    I have this one who works perfect :
    Please Login or Register  to view this content.
    get the fee time stamp with 2 conditions : orderId and lots
    now i want to lighten my file and take the 2nd condition out as OrderId is a unic number

    so I made
    Please Login or Register  to view this content.
    but no matter what I change or do
    he always give the value of the LAST CELL in that column ???

    heeelp

    same formating
    no spaces

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: index match give wrong cell TRIED EVERYTHING !

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: index match give wrong cell TRIED EVERYTHING !

    Attach a sample workbook (not image).

    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.

  4. #4
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    Re: index match give wrong cell TRIED EVERYTHING !

    OW MY GOD Trevor !

    I breaking my head 1 hour, and you magically solved it,

    Thank you so much, !!
    Chris

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: index match give wrong cell TRIED EVERYTHING !

    You're welcome. Thanks for the 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. Index/Match wrong?
    By Lugashz in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-25-2017, 10:09 AM
  2. [SOLVED] =INDEX($N$3:$Q$100,MATCH(1,($A$2=$N$2:$N$100)*($B$2=$Q$2:$Q$100),0)) what wrong
    By hktom in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2015, 11:10 PM
  3. [SOLVED] Row and column match? (IF INDEX MATCH) What am I doing wrong.
    By Noop1887 in forum Excel General
    Replies: 2
    Last Post: 01-04-2015, 09:16 AM
  4. [SOLVED] Using Address, Index, Match and Max to give the cell location
    By JmundleBofA in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-26-2014, 07:23 PM
  5. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  6. [SOLVED] Match Column And Row to give value, index and match?
    By zhunter71 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2013, 01:05 PM
  7. Index and Match-wrong value
    By Steved in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2005, 07:06 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