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?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!