index match first non blank cell

  • I have a formula that gives me a blank cell because the first match for the company name in the date field is blank. IFERROR(INDEX('QB-GenCleanReport'!H:H,INDEX(MATCH("*"&A2&",*",'QB-GenCleanReport'!B:B&",",0),)),"") Col B is the Company name that should match A2 and Column H has the dates. The dates are in descending order however some of the company names which have several entries do not have a date. How do I fix this to give me the most current date that is not blank?

  • Hi,


    With a small sample file attached ... for sure you would get several proposals for a concrete solution ...:wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!