Hey there,
I'm trying to search a range of cells from left to right to see if two criteria are met, and if so, display the related date of the first instance found with a preceding asterisk. The two criteria are as follow:
1. Does the value in the cell contain an asterisk?
2. Is its associated date greater than or equal to today's date?
I've come up with this formula, but it only gives me results for the first instance found and ignores any others:
The example Google Sheet can be found here. If I remove the asterisk from cell B4, the formula returns the date from cell E4 properly, but when I enter an asterisk to cell B4, cell E4 is completely ignored. Does anyone know what am I doing wrong?Please Login or Register to view this content.
Bookmarks