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?
Bookmarks