LOOKUP Articles: Excel and Google Sheets

With the help of the MAX and MATCH functions in excel, we can now easily get the position of the maximum value in excel. This post provides a clear guide on how to use these functions to get the position of the max value in list. Figure 1: Finding position...

Figure 1. of March First Error Function. If we want to match the first error entry within a cell range, we can use a formula which is based on the ISERROR and MATCH Functions in Excel. This article will step through the process. Generic Formula =MATCH(TRUE,ISERROR(rng),0) The operation syntax displayed...

We can use the MATCH function to lookup the next largest match in a given set of values. This function is used in an approximate match mode, with -1 being for the match type. This post provides a clear guide on how to use the MATCH function to lookup the...

We can break ties (the same values) in a data with the COUNTIF function and a helper column. This effectively removes duplicates and removes confusion about the data. The steps below will guide all levels of excel users through the process. Figure 1: How to Break ties with helper column...

If you want to search for the presence of a certain entry in a list then making a comparison of those entries with that of the list containing the data will be helpful. The formula presented in this article will make use of IF and COUNTIF statements. Find Missing Values...

We can now match the next highest value in a lookup table using a formula that is based on INDEX and MATCH functions. To learn how this is done, read this post to the end. Figure 1: How to match next highest value with MATCH and INDEX General syntax of...

While working with Excel, we are able to retrieve data from a dataset based on an exact match by using INDEX and MATCH functions.  The INDEX function returns a value as specified from within a range, while the MATCH function returns the position of a value in a range. This...

Figure 1. of Basic INDEX MATCH Approximate. In the event that we are required to locate the right row for an approximate matching value in our Excel sheet, we can use the INDEX MATCH functions in Excel. This tutorial will walk through process. Generic Formula =INDEX(grades,MATCH(score,scores,1)) This operation syntax needs...

While working with Excel, we are able to retrieve a value from a dataset through lookup based on a lowest value by using the INDEX, MATCH and MIN functions.  This step by step tutorial will assist all levels of Excel users to look up a value based on a lowest...

While working with Excel, we are able to lookup a value and retrieve data from a data set using the VLOOKUP function.  However, when we need to work with two lookup tables, we retrieve data from the appropriate table by using the VLOOKUP and IF functions. This step by step...