+ Reply to Thread
Results 1 to 10 of 10

Index & Match formula to find first item in Col K tht is not blank or zero

Hybrid View

  1. 01-30-2019, 01:51 PM #1
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: Index & Match formula to find first item in Col K tht is not blank or zero

    Open Book4 and Book2 from attached.

    Xlent's formula in D1 and my in E1
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    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. [SOLVED] Need Index/Match to find the first non-blank cell and return the value in the top row
    By royalbluestuey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2018, 01:43 PM
  2. [SOLVED] Index match formula help - get nth non blank text
    By Jason Toh in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-23-2017, 07:37 AM
  3. [SOLVED] Find item(s) in a cell and match to item(s) in a list
    By seleseped in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2017, 12:06 PM
  4. [SOLVED] Formula to find 2nd Match using Index and 2 Match conditions
    By Cra5h in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-24-2016, 11:52 AM
  5. Index/ Match Formula, How to return blank cell as a blank not 0
    By MDResearcher in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2016, 08:40 PM
  6. Index/Match/Match. Formula looking veritcal and horizontal headings to find a match
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-29-2012, 08:51 PM
  7. Index and match, matching with one more item (Item A and B)
    By ronlau123 in forum Excel General
    Replies: 9
    Last Post: 05-21-2011, 12:14 AM

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