# Extract Multiple Matches into Separate Columns in Microsoft Excel

Written by | 0 Comments | 279 Views

In this article, you will learn how to evaluate things based on the LOOKUP function in Microsoft Excel using a single/combination(s) of functions. You will also know to Extract Multiple Matches into Separate Columns and see the generic formula.

Learn to Extract Multiple Matches into Separate Columns in Microsoft Excel

The main purpose of this formula is to extract multiple matches to separate cells, in separate columns. Here we will learn how to extract multiple matches into separate columns in the given data range in the workbook in Microsoft Excel. That implies, with the help of a formula based on the INDEX, and SMALL functions you can able to extract multiple matches to separate cells, in separate columns. So, with the help of this formula, you can able to extract multiple matches into separate columns in the given data range in the workbook in Microsoft Excel.

General Formula to Extract Multiple Matches into Separate Columns

=IFERROR(INDEX(names,SMALL(IF(groups=\$E5,ROW(names)-MIN(ROW(names))+1),COLUMNS(\$E\$5:E5))),"")

The Explanation to Extract Multiple Matches into Separate Columns

So we know that with the help of the given formula above you can able to extract multiple matches to separate cells, in separate columns. Here we will learn how to extract multiple matches into separate columns in the given data range in the workbook in Microsoft Excel. As we know that we are using the SMALL function to generate a row number that corresponds to the "nth match". When we have the row number, we simply pass it into the INDEX function, which returns the value at that row. So now you have learned how to extract multiple matches into separate columns in the given data range in the workbook in Microsoft Excel.