pwrMATCH

PowerUp Description

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.

PowerUp Syntax

pwrMATCH(lookupvalue, tablearray, [strength], [sensitivity], [bestmatch])

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.

sensitivity – Optional. This is a value between 2 and 5 (inclusive). The value determines how wide a view the lookup will have across the matching text. The default value is 3.

bestmatch – Optional. Set to TRUE to find the best match. The default value is FALSE, which will return the first match meeting the criteria.

Return Value

pwrMATCH will return the row or column number of the matching cell.

Remarks

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.

Example

=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.

Here are some related posts:

pwrHLOOKUP pwrVLOOKUP pwrCONCATENATE pwrSIMILARITY pwrRANDFROMRANGE