Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles LOOKUP How to Find the First Match in a Range with a Wildcard

How to Find the First Match in a Range with a Wildcard

Figure 1. of the Index and Match Operation in Excel.

In order to determine the value of the first match in an array of data, with the use of a Wildcard, we can utilize an Index and Match operation syntax, configured to find an exact match.

Generic Formula

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

How the Function Operates

  1. First, we must properly identify and arrange the data set we intend to index and match in our Excel worksheet. In the example below we are working with a data set of courses offered by three (3) different university Students in a semester.

Figure 2. of Data set for Indexing and Matching in an Excel sheet.

  1. Input the Tag/Search name of the value for which we want the range values, in the next column of our worksheet.

Figure 3. of Search name entered.

  1. Label the next column as “Result” and then we can now proceed to input the formula syntax

=INDEX(A2:D2,MATCH(D2&"*",A2:D2,0)) within cell E2, to obtain our Index and Match result.

Figure 4. of entering formula for using First Match in Range with Wildcard.

In this post, we have illustrated how we can utilize the MATCH Function to identify the position of the first match within the cell range A2:C2 of our worksheet. Our look_up value is based on the value in A2 connected with an asterisk (*) utilized as a Wildcard. Our match_type  is set to 0, so that we can obtain an exact match. The goal is to obtain the first match within an array by using a Wildcard Function.

Figure 5. of Final Result.

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc