Hi all,
I have an INDEX MATCH formula that has been causing me some issues. I thought I had solved the issue as it's been months since the formula hasn't worked properly but now the issue has arisen again.
I have attached my workbook. The issue is with the formula in cell E18 on the Summary sheet. The odd thing is if you manually change the minimum value from 54.4 to any other value then the date it occurred is returned.
Thanks,
Luke
Bookmarks