If you don't specify the last parameter Excel does a "close enough is good enough" match which is REALLY annoying to debug.
A good general resource of the VLOOKUP function is here:
https://www.ablebits.com/office-addins-blog/2014/07/17/excel-vlookup-tutorial-beginner/
No comments:
Post a Comment