LinkedIn Facebook Twitter Gmail On Default, VLOOKUP is not case sensitive thus it does not do an Exact match lookup. It is even harder for VLOOKUP to do an exact partial match lookup and return multiple results. This article will show you how to resolve the above difficulties by nesting IF, SMALL, EXACT and CHOOSE … Continue reading VLOOKUP Exact Partial Match (Multiple Results)