+ Reply to Thread
Results 1 to 9 of 9

Index and match not working

  1. 07-28-2023, 01:28 PM #1
    Ranbir
    Ranbir is offline
    Registered User
    Join Date
    10-21-2008
    Location
    Delhi, India
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    45

    Index and match not working

    hi,

    I have 2 sheets 1. LR_CNF and 2. Summary

    LR_CNF sheet has container-wise loading data and we put BL no. against each container as
    they sail and BL is issued.

    in the Summary Sheet, UNDER BL STATUS we intent to summarize BL only. if BL Coloumn is blank it should not be
    populated

    the formula used was working initially and now it stopped and not pulling the BL nos after more
    containeers are inserted in this sheet.

    Kindly help is sorting the mistake if any in the formula or else advise.


    Thanks
    Ranbir
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-28-2023, 02:09 PM #2
    JohnTopley
    JohnTopley is online now
    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,215

    Re: Index and match not working

    What should be in B20?

    Guessing .. this finds first non-blank entry ........

    Please Login or Register  to view this content.
    in G20

    Please Login or Register  to view this content.
    Last edited by JohnTopley; 07-28-2023 at 04:22 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 07-28-2023, 02:28 PM #3
    Ranbir
    Ranbir is offline
    Registered User
    Join Date
    10-21-2008
    Location
    Delhi, India
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    45

    Re: Index and match not working

    Hi,

    BL no fetched from Sheet LR_CNF..
    Reply With QuoteRegister To Reply
  4. 07-28-2023, 02:37 PM #4
    JohnTopley
    JohnTopley is online now
    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,215

    Re: Index and match not working

    See updated post#2
    Reply With QuoteRegister To Reply
  5. 07-28-2023, 03:30 PM #5
    TMS
    TMS is offline
    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,467

    Re: Index and match not working

    The first few entries on LR_CNF are blank. That seems to be causing the problem. Is that to be expected? If I put some random values in there, the table populates as (I assume) it should.
    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

    Reply With QuoteRegister To Reply
  6. 07-29-2023, 08:01 AM #6
    Ranbir
    Ranbir is offline
    Registered User
    Join Date
    10-21-2008
    Location
    Delhi, India
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    45

    Re: Index and match not working

    Hi,

    Thanks John and TMS for pointing the reason.

    now comes another issue, it's working either for text or number not for both the cases... its working only for the number or text whichever is coming first.

    eg. if text comes first ...numeric values are not coming and vice-versa.

    Please suggest if there is any other or alternate way to do the same.

    Thanks
    Ranbir
    Last edited by Ranbir; 07-29-2023 at 08:14 AM. Reason: edited the question and reply
    Reply With QuoteRegister To Reply
  7. 07-29-2023, 08:02 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,987

    Re: Index and match not working

    Which version of Excel are you using?

    Your thread title should tell us what you are trying to do, NOT that something isn't working. Please remember this in future.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  8. 07-29-2023, 08:15 AM #8
    Ranbir
    Ranbir is offline
    Registered User
    Join Date
    10-21-2008
    Location
    Delhi, India
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    45

    Re: Index and match not working

    hi,

    I am using office 365 version.

    Thanks
    Ranbir
    Reply With QuoteRegister To Reply
  9. 07-29-2023, 08:31 AM #9
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,987

    Re: Index and match not working

    Please add that to your forum profile.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 Match for pricing matrix not working
    By ADR90 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2020, 12:01 AM
  2. Index Match Match - 2 x Vertical Lookups - Not working as it should
    By seash in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2016, 09:58 AM
  3. [SOLVED] help index and match macro not working but formula working??
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2016, 06:37 AM
  4. [SOLVED] Working INDEX MATCH with SEARCH, but I need to add another MATCH to the formula!
    By DaveBre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2014, 01:03 AM
  5. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  6. INDEX MATCH MATCH working great and then failing on me.
    By HeikEve in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2013, 01:40 PM
  7. INDEX MATCH MATCH working fine and then NOT WORKING for a random row or two.
    By HeikEve in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2013, 09:32 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1