How to Use the MATCH Function in WPS on Windows

Use the MATCH function in WPS Spreadsheets on Windows with 3 how-to topics; all 3 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Insert MATCH from the Insert Function dialog

Entry point: Formula tab → Insert Function

1. Open WPS Spreadsheets and select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for MATCH in the dialog box.
4. Select MATCH and click OK.
5. Enter the lookup value, lookup range, and match type in order.
6. Click OK to finish entering the function.

Success Criteria

• Interface result: The target cell now contains a MATCH formula.
• What you can do next: You can continue editing arguments, press Enter to confirm, or fill the formula down.

Tips While Using

• The lookup range should be a single row or a single column so the returned position is clear.
• The match type affects the result. For unsorted data, an exact match setting is commonly used.

2. Type the MATCH formula directly in a cell

Entry point: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =MATCH(...) directly.
3. Fill in the arguments based on your data.
4. Press Enter to confirm.
5. If needed, drag the fill handle or copy and paste the formula to other cells.

Success Criteria

• Interface result: The cell returns a position number or a related error message.
• What you can do next: You can continue editing the formula, adjust references, or copy it to other cells.

Tips While Using

• The return value is a position number, not the matched text or number itself.
• When copying the formula in bulk, check whether relative and absolute references are set as intended.

3. Review MATCH syntax and arguments

Entry point: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Search for and select MATCH.
3. Review the syntax structure and argument names in the function description area.
4. Open the related help entry to read more detailed argument guidance.
5. Return to the worksheet and adjust the formula as needed.

Success Criteria

• Interface result: You can see the MATCH syntax, argument order, or help details.
• What you can do next: You can re-enter or correct the formula based on the guidance.

Tips While Using

• If the result is different from what you expect, check the argument order and match type first.
• If the lookup value format does not match the data format in the range, the result may be incorrect.