Not actually vlookup but index/match...same difference.
I have this index/match formula, click and drag down...most items return the result I'm looking for, but some come back with #N/A. The number it is returning is the result of a SUMIF formula. I've tried ROUND(xx,2), but still nothing. When I copy and paste as value, the index/match formula returns a good result.
Any thoughts as to why it works SOMETIMES only?
let seen that file
Thanks for the help
It's a floating decimalproblem, (cant remember rhe link that explains it), but change the formula in 2, column H to this, and copy down...
=ROUND(SUMIFS(A:A,C:C,G5),2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks!
I was only doing that with the sum range, not the result itself, leading me to think that wasn't it.
Curiosity, why is it then that EXACT returns TRUE?
excel can only handle a 16-digit number. It drops off all values past that amount. There are apparently some values that, while they appear to be just to 2 dec, do in fact go out to way past that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks