by Crispo Mwangi | Dec 26, 2022 | INTERMEDIATE EXCEL
Many users think you cannot use multiple criteria in a VLOOKUP Function, but this is wrong. =VLOOKUP( G2&H2, CHOOSE( {1,2},sales[Name]&sales[Region],sales[Date]) ,2,FALSE) DOWNLOAD...
by Crispo Mwangi | Dec 23, 2022 | INTERMEDIATE EXCEL
Initializing a single middle name is easy using a simple 3 steps: =LEFT(name,FIND(” “,name)) & IF(COUNTIF(name,”* * *”),MID(name,FIND(” “,name)+1,1)&”. “,””) & RIGHT(name,LEN(name)-FIND(”...
by Crispo Mwangi | Nov 24, 2022 | INTERMEDIATE EXCEL
Of all lookup functions, HLOOKUP is among the least famous ones. It looks up a value in the first row and returns any corresponding item in another row. Look up value MUST be in the top row of a table. How do you make it return multiple items? It’s default...
by Crispo Mwangi | Nov 16, 2022 | INTERMEDIATE EXCEL
VLOOKUP function is mostly underrated and assumed that it cannot return multiple items. The only trick is to use row numbers as lookup values…VLOOKUP can loop through numbers one at a time and return corresponding values. =VLOOKUP(...
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