LOOKUP in WPS on Windows FAQ

Last updated:July 20, 2026

When using LOOKUP, common questions usually involve formula errors, argument understanding, unexpected results, and recalculation checks. This section covers 4 frequent questions.

FAQ

What should I do if LOOKUP shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether the parentheses are paired correctly and whether the arguments are separated correctly.
  3. Use the syntax prompt to confirm that the lookup value, lookup range, and return range are complete.
  4. Press Enter again to submit the formula.

How can I view the LOOKUP argument description?

  1. Select the target cell.
  2. Type =LOOKUP(.
  3. Check the syntax prompt that appears near the formula bar.
  4. Follow the prompt to enter the arguments and review the result.

Why is my LOOKUP result not correct?

  1. Check whether the lookup range is arranged in the order required by the formula.
  2. Check whether referenced cells contain numbers stored as text or blank values.
  3. Confirm that the cross-worksheet reference uses the correct row or column range.
  4. After changing data, check whether the result updates automatically, and press F9 if you need to recalculate manually.

Can LOOKUP be used for cross-worksheet lookup?

  1. Yes. While editing the formula, switch to another worksheet and select the referenced range.
  2. Make sure the lookup range and return range correspond correctly.
  3. Complete the formula and press Enter.
  4. Return to the current worksheet and check whether the result is correct.

Glossary

TermDefinition
LOOKUPA lookup and reference function in a spreadsheet that finds a value in a specified range and returns the corresponding result from the matched position.
Syntax promptThe on-screen argument hint shown while entering a function, helping you confirm argument order and input format.
Cross-worksheet referenceA formula reference that uses a cell or range from another worksheet.
RecalculationThe process of running spreadsheet formulas again to refresh results after data changes.