excel INDEX

How to Extract a Unique Distinct List from a Column in Excel

This post will guide you how to extract a unique distinct list from two or more columns in Excel. How do I get a list of distinct values in multiple columns with a formula in Excel. How to create a list of unique values from a range of cells using VBA Code in Excel. Extract… read more »

How to Return Cell Address Instead of Value in Excel

This post will guide you how to lookup value and return cell reference containing that value in Excel. How do I return cell address from a lookup result with a formula in Excel. Return Cell Address From Lookup Result Normally, you can use INDEX/MATCH function to lookup a value in a given range of cells,… read more »

How to Look up Value and Return Adjacent Cell Value in Excel

This post will guide you how to lookup a value from a range of cells and return match from adjacent cell in Excel. ¬†How do I Vlookup a value and return a value in corresponding, adjacent cell in Excel. Look up Value and Return Adjacent Cell Value Assuming that you have a list of data… read more »

How to Get the First, 2nd or Nth Match Using Vlookup/Index/Match

This post will guide you how get the nth matching values with VLOOKUP function in Excel. How do I find the nth match value with Index/Match formula in Excel. How to find the first, second, third or nth matching value from a range of cells using VLOOKUP formula. Find the First Match Value Using VLOOKUP… read more »

Find Closest Value or Nearest Value in a Range in Excel

This post will guide you how to find the closest value or nearest value in a range of cells or in a column in Excel. How do I find the closest match in a range to a given lookup value in Excel. How to find the closest larger and closest smaller values from a range… read more »

Generate All Possible Combinations of Two Lists in Excel

This post will guide you how to generate all possible combinations with a formula in excel. How do I create list with all possible combinations of two lists in Excel. How to list all combinations from two separate list or range in Excel. Generate All Possible Combinations of Two Lists in Excel Assuming that you… read more »

Copy and Paste Only Non-blank Cells

This post will guide you how to copy and paste only non-blank cells in Excel 2013/2016. How do I copy only non blank cells with VBA code in Excel. Or how to get non-blank cells from a range of cells with a formula in Excel. This post will introduce four methods to copy and paste… read more »

VLOOKUP Return Multiple Values Horizontally

This post will guide you how to vlookup a value and then return multiple corresponding values horizontally in Excel. How do I lookup a value and return multiple matched values in the same row in Excel. Or how to return multiple values with VLOOKUP function in Excel. VLOOKUP Return Multiple Values Horizontally Assuming that you… read more »

Sidebar