The default behaviour of the VLOOKUP function is to look up values from left to right. When you try to do it the other way round by looking up value from right to left, Excel returns an #N/A error. To surmount this limitation associated with the VLOOKUP function, you will have to employ an advanced …
The column function returns the position of the column that is being referenced While the columns function returns the number of columns in the range or array. In the video tutorial below, I will show you the different scenarios of how these functions work. Using this function alongside other Excel functions can make your formula …
HOW THE COLUMN & COLUMNS FUNCTION WORKS IN EXCEL Read More »
When you use the conditional formatting feature in Excel to highlight duplicate values only, you will notice that any value that appears more than once will be highlighted not minding that your goal is just values that appear twice on your data set. To find only duplicate values on your data set, you will need …
HOW TO USE FORMULA TO FIND DUPLICATES AND TRIPLICATES IN EXCEL Read More »
Searching for an exact and partial word across multiple columns makes it easier to filter results that meet such criteria in the entire database. One of the benefits of using this search box feature is the ability to filter the results of the search item unto a different section for easy visibility and decision making. …
HOW TO DESIGN A SEARCH BOX THAT FILTER EXACT & PARTIAL MATCH ACROSS MULTIPLE COLUMNS Read More »
The INDEX function returns a specific value from a one-dimensional or two-dimensional range. The MATCH function returns the relative position number of an item. The INDEX function actually returns the value in the cell, not the position. Let’s examine the INDEX function syntax below =INDEX (array, row_num, [column_num]) The array (First argument) is the range …
