Tuesday, September 20, 2016

When using VLOOKUP in Excel make sure to use the FALSE parameter on the end

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: