LOOKUP Articles: Excel and Google Sheets

There are times when we want to lookup a value in an excel table using both the rows and columns. To do this, we need to build a formula that is based on a two-way lookup with INDEX and MATCH as explained in this article. Figure 1: How to do...

If you want to search for a word or a string in an Excel sheet, a check can be made on each cell to look for that string or word. Moreover, a counter can also be initialized that will intimate the number of repetitions of a string in a selected number...

Microsoft Excel is a well-known tool for calculating grades with VLOOKUP function. VLOOKUP function is one of the commonly used functions on Excel, and it allows its user to calculate grades on Excel. The following comprehensive guideline discusses a simple systematic method, which anyone can use to calculate their grades...

Excel allows us to a position of the first partial match in a range, by using the MATCH function. The function returns the first row where the selected string is founded. This step by step tutorial will assist all levels of Excel users in finding a position of the first...

While working with Excel, we are able to lookup a value and retrieve data from a data set using the VLOOKUP function.  VLOOKUP provides a quick way of looking up a value from any list or range.  This step by step tutorial will assist all levels of Excel users to...

VLOOKUP provides a quick way of looking up a value from any list or range.  However, if a value is not found, VLOOKUP returns an error value #N/A. This step by step tutorial will assist all levels of Excel users in returning a custom value instead of error values by...

Excel allows us to lookup with dynamic column number parameter in the VLOOKUP function using MATCH function. This step by step tutorial will assist all levels of Excel users to do the two-way lookup. Figure 1. Find value per store and week with VLOOKUP and MATCH functions Syntax of the...

Generally, we look up for the required information in a large dataset using INDEX, MATCH functions and return the matching value based on given criteria. But if we want to look up a value and return the cell reference or the cell address of resulting value then we need to...

The HLOOKUP function is excel is fundamental when it comes to looking up and retrieving a text value in a given range of columns. This article looks at how one can get the first text value with HLOOKUP. Figure 1: How to find first text value in a list in...

The EXACT function works as a lookup tool. However, it is case-sensitive. This function compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. In this post, EXACT will be used with SUMPRODUCT function to illustrate how EXACT function works. Exact match lookup with SUMPRODUCT Generic...