by Crispo Mwangi | Oct 19, 2022 | INTERMEDIATE EXCEL
Among many misconceptions about the VLOOKUP function is that it cannot return items repeated n times. This is not true! For example, Using the data below, can you return the names of the customers who have bought 3 times using VLOOKUP? Here are the steps: Create a...
by Crispo Mwangi | Oct 6, 2022 | INTERMEDIATE EXCEL
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,...
Recent Comments