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
Last edited by lukela85; 12-18-2017 at 11:11 AM.
54.44 and 54.40 are not an exact match - simple as that.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Its a rounding issue I think. Putting ROUND() in the first argument of MATCH makes it return a result.
My guess is that due to the operations on the 54.4 (or .544) when multiplying or dividing (as you do in multiple different places in preceding formulas) that they are a small tiny fraction different than each other but that difference doesn't seem to be displayed any place.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
Thanks to both of you for your help.
You're right, Zer0, I don't really understand what is happening when the number is multiplied but adding ROUND fixes the issue.
Marked as solved and reputation added.
Thanks for letting us know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks