Hi Forum,
I have an array formula that takes a value in cell C2, finds any matching values in the range $A$2:$A$30000 and then returns the latest date associated with these values (the dates are in the range $B$2:$B$30000). This works well.
The problem I have is that when a date is not found in the range $B$2:$B$30000 it returns 00-Jan-00. I think this is because of the zero at the end of my formula which returns zero and then my date formatting shows that as 00-Jan-00. I need it to just show an empty cell ("") instead of 00-Jan-00.
I have tried using "" instead of zero (see formula below) but it returns #Value instead of an empty cell.
I also want it to return an empty cell ("") if the value in C2 is not found in the range $A$2:$A$30000. Again, it is presently returning 00-Jan-00 in these cases.
Please see attached example spreadsheet.
I have spent a lot of time experimenting with my formula but have not been able to get the result I need.
Any assistance would be greatly appreciated.
Dave
Bookmarks