Microsoft Excel

How to Get First Match in Range With Wildcard in Microsoft Excel

Learn How to Get First Match in Range With Wildcard in Microsoft Excel

The main purpose of this formula is to get the value of the first match in a range using a wildcard. Here we will learn how to get the first match in the given data range in the workbook in Microsoft Excel.

That implies, with the help of a formula based on the INDEX, and MATCH functions, you can able to get the value of the first match in a range using a wildcard.

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

 

General Formula to Get First Match in Range With Wildcard 

=INDEX(range,MATCH(val&”*”,range,0))

 

The Explanation to Get First Match in Range With Wildcard

How to Get First Match in Range With Wildcard in Microsoft Excel

 

So we know that with the help of the given formula above, you can able to get the value of the first match in a range using a wildcard. Here we will learn how to get the first match in the given data range in the workbook in Microsoft Excel.

As we know that the MATCH function is used to locate the position of the first match in the range. The lookup value is based on the value in B5 joined with an asterisk (*) as a wildcard, and the match type is set to zero to force an exact match. So now you have learned how to find the first match in the given data range in the workbook in Microsoft Excel.