The pwrMATCH PowerUp function looks up a value in a table or range of cells and returns the row or column number of the matching cell. The match in pwrMATCH can be either exact or fuzzy to varying degrees.
pwrMATCH(lookupvalue, tablearray, strength)
The pwrMATCH PowerUp function has the following arguments:
lookupvalue – Required. This is the value to be searched for in the tablearray.
tablearray – Required. This is the range of cells from which to find the match. tablearray must be either a single column or a single row of data.
strength – Optional. This is a value between 0 and 100. If not provided, the default value used is 100. This will return an exact (or 100%) match. To perform a fuzzy match, use a smaller number (for example, 50) to indicate a lower strength of match.
pwrMATCH will return the row or column number of the matching cell.
You can vary the strength of match as needed to achieve the degree of fuzziness required. A good starting value is 50, but you can increase or decrease as needed.
=pwrMATCH("John Smith", A1:A1000, 50)
Would be able to match a row with the value “John Smythe” and return the corresponding row number from the range.