Microsoft Excel

Learn How to Get Last Match Cell Contains in Microsoft Excel

Learn How to Get Last Match Cell Contains in Microsoft Excel

The main purpose of this formula is to check a cell for one of several things and return the last match found in the list. Here we will learn how to get the last match cell contains in the given data range in the workbook in Microsoft Excel.

That implies, with the help of a formula based on the LOOKUP and SEARCH functions, you can able to check a cell for one of several things and return the last match found in the list.

So, with the help of this formula, you can able to get the last match cell contains in the given data range in the workbook in Microsoft Excel.

 

General Formula to Get Last Match Cell Contains

=LOOKUP(2,1/SEARCH(things,A1),things)

 

The Explanation to Get Last Match Cell Contains

Learn How to Get Last Match Cell Contains in Microsoft Excel

 

So we know that with the help of the given formula above, you can able to check a cell for one of several things and return the last match found in the list. Here we will learn how to get the last match cell contains in the given data range in the workbook in Microsoft Excel.

As we know that when SEARCH finds a match, it returns the position of the match in the cell being searched. In case the search can’t find a match, it returns the #VALUE error.

As we are giving SEARCH more than one thing to look for, it will return more than one result. In the example shown, SEARCH returns an array. So now you have learned how to get the last match cell contains in the given data range in the workbook in Microsoft Excel.