1 June 2015
By default, Excel (and most other spreadsheet systems too) return approximate matches when using the VLOOKUP function.
There is a benefit in using the approximate match, it is quicker (as binary search is used) but for small spreadsheets the difference is negligible.
The interesting thing is that there are risks associated with using the approximate match. Because it uses binary search it requires the search range to be sorted. If not, funky things can happen.
Full article: VLOOKUP considered harmful
