When using MATCH in WPS Spreadsheets, common questions usually involve errors, unexpected results, and filling formulas across cells; this section includes 3 FAQs and 3 glossary terms.
FAQ
What should I do if MATCH returns an error value?
- Check whether the number and order of arguments are correct.
- Make sure the lookup value and the data in the lookup range use matching data types, such as text versus numbers.
- Confirm that the lookup range is a single row or a single column.
- If extra spaces exist, clean the data and try the match again.
Why does MATCH return a result that is different from what I expected?
- Check whether the third argument uses the correct match type for your data.
- If you use approximate matching, confirm that the lookup range is sorted as required.
- Remember that MATCH returns a position number rather than the target value itself.
- If you need the actual returned content, combine MATCH with another reference function.
How can I use MATCH across multiple cells?
- Enter the MATCH formula in the first cell and confirm that the result is correct.
- Drag the fill handle downward, or copy and paste the formula into the target range.
- Lock the lookup range when needed so the reference does not shift after copying.
- Spot-check several results after filling to confirm that the references are correct.
Glossary
| Term | Definition |
|---|---|
| lookup_value | The target value to search for. It can be text, a number, or a cell reference. |
| lookup_array | The range used for the search. It is usually set as a single row or a single column. |
| match_type | The matching mode argument that controls whether the function uses exact or approximate matching logic. |