excel index match - Free Excel Tutorial

How to Lookup the Next Largest Value

This post will provide you with two different methods to lookup the next largest value in Excel: using a formula and using VBA code. While both methods achieve the same result, they differ in their implementation and can be used depending on your specific requirements. 1. Find the Next Largest Value Using Formula If you… read more »

How to get nth Match with One Criteria using INDEX/MATCH

This post will guide you how to get nth match based on one criteria with INDEX and MATCH in Excel. In the previous post, we used one excel formula to get the position of the nth occurrence of a value based on one criteria. 1. Get nth Match with One Criteria using INDEX/MATCH Formula At… read more »

How to Extract a List of Unique Values from a Column Range

This post explains that how to get the unique values from a range or column in excel. How to extract unique values from a list or excel range in excel 2013. Extract unique values If you want to extract a list of unique items from a column or range, you can use a combination of… read more »

How to Get the First Match in Two Excel Ranges

This post will guide you how to get the first match value in two ranges in excel. How to return the first occurrence of the value in two excel ranges. Get the First Match in two Ranges If you want to find the first match between two excel ranges, you can use a combination of… read more »

How to Get Cell Address of a Lookup Value

This post explains that how to lookup a value from a range or array, then return cell address from a lookup result in excel. How to get the cell reference of lookup result in a range. Get Cell Address (reference) of a Lookup Value If you want to lookup a value in a range or… read more »

Two-way Lookup Formula

This post explains that how to use two way lookup formula to find a value in a table or in a two dimensional range in excel. How to lookup a value in a table using given row and column with INDEX and MATCH functions. Or how to do perform a two way lookup with VLOOKUP… read more »

How to SUM a Column with Lookup value in a Range

We have described that how to lookup value and retrieve the entire column in the previous post. And this post will guide you how to get the sum of the entire column with lookup value in a range in excel. SUM Column with Lookup Value If you want to lookup value in a range and… read more »

How to Extract the Entire Column of a Matched Value

In the previous post, we talked that how to lookup value and then returns entire rows of a matched value in a range. And this post will guide you how to lookup value and then return the entire column of the first matched value in a range in excel. How to use INDEX/MATCH to lookup… read more »

How to Lookup Entire Row using INDEX/MATCH

This post explains that how to lookup entire row and return values of the entire row in a table or range in excel. Lookup Entire Row If you want to lookup entire row and then return all values of the matched row, you can use a combination of the INDEX function and the MATCH function… read more »

How to find the nth Largest Value

In the previous post, we talked that how to get the nth smallest value in a range and how to get the relative value of the same row of the nth smallest value in a range or array. And this post will guide you how to get the nth largest value in a range in… read more »

How to Find the nth Smallest Value

This post explains that how to get the nth smallest value in a single column, or single row or an array list in excel. How to extract relative value in the same row based on the position of the nth smallest value in a single column. Find the nth Smallest value You can use the… read more »

How to find nth Occurrence with Multiple Criteria Using INDEX/MATCH

This post explains that how to get the nth occurrence value with multiple criteria using INDEX and MATCH in excel. How to find the first, second or nth match with multiple criteria in excel. How to return the nth match on a multiple criteria using INDEX and MATCH. In the previous post, we talked that… read more »

How to Transpose Values Based on the Multiple Lookup Criteria

This post explains that how to transpose values from columns to rows based on the multiple lookup criteria in excel. In the previous, we talked that how to transpose values from columns to rows using Paste Special Transpose, it’s just rearrange all data in a range and do not apply for any criteria. Transpose Values… read more »

Sidebar