MATCH in WPS on Windows FAQ

Common questions about MATCH usually involve formula errors, argument handling, and result checks; this section covers 4 frequent questions.

FAQ

What should I do if the MATCH function shows an error after I enter it?

1. Check whether the formula starts with =.
2. Check whether the parentheses are paired correctly and the arguments are separated correctly.
3. Review the syntax prompt to confirm the number and order of arguments.
4. Press Enter again and review the result.

How can I view the argument guidance for the MATCH function?

1. Select the target cell and type =MATCH(.
2. Look for the syntax prompt near the formula bar.
3. Fill in the lookup value, lookup range, and match argument in order.
4. If you need to revise the formula, stay in edit mode and adjust the arguments.

Why does MATCH return a position that is different from what I expected?

1. Check whether the lookup range is correct, especially the start and end cells.
2. Check whether the match argument fits the lookup method you want.
3. Confirm that the lookup value and the data in the range use compatible data types.
4. Recalculate and compare the returned position again.

What should I do if the result does not update as expected after the data changes?

1. Confirm that the edited data is inside the range referenced by MATCH.
2. Check whether the formula has been changed into text format.
3. Select the result cell again and confirm that the formula is still complete.
4. Trigger recalculation and review the updated result.

Glossary