How to Use the XLOOKUP Function in WPS on Windows

This how-to guide includes 4 topics for using XLOOKUP in WPS on Windows, with 4 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Enter the XLOOKUP function

Feature entry: Formulas tab → formula bar, or select a cell and type directly

1. Open WPS Spreadsheets and select the cell where you want to enter the formula.
2. Type = to begin a formula.
3. Type XLOOKUP(.
4. Keep the cursor inside the parentheses so you can continue entering arguments.

Success Criteria

• The cell or formula bar shows =XLOOKUP(.
• You can continue entering the lookup value, lookup range, and return range.

Tips While Using

• If you do not start with =, the content may be treated as plain text.

2. Review syntax guidance and fill in arguments

Feature entry: the function guidance area that appears after you type XLOOKUP(

1. After typing XLOOKUP(, review the syntax guidance shown in the interface.
2. Enter the required arguments in the suggested order.
3. Check that the parentheses, separators, and ranges are complete.
4. Press Enter to confirm the formula.

Success Criteria

• Function guidance is visible and the formula is accepted.
• The cell shows a result or is ready for further editing.

Tips While Using

• Missing arguments, unmatched parentheses, or incorrect separators can cause formula errors.

3. Use cross-sheet references

Feature entry: switch to another worksheet while editing the formula

1. In the XLOOKUP formula, place the cursor where the lookup range or return range should be inserted.
2. Switch to another worksheet.
3. Select the target cell range.
4. Return to the result cell and confirm that the reference is complete.

Success Criteria

• The formula includes a reference to another worksheet.
• Pressing Enter returns a result from the referenced data.

Tips While Using

• If the lookup range and return range do not align, the result may not match your expectation.

4. Finish a nested formula and check live updates

Feature entry: formula bar

1. Add another function around XLOOKUP or inside one of its arguments.
2. Check that all nested parentheses are paired correctly.
3. Press Enter to complete the formula.
4. Change the source data and review whether the result updates automatically.

Success Criteria

• The formula returns a result and updates when source data changes.
• You can continue copying the formula or adjusting the referenced ranges.

Tips While Using

• When the formula becomes long, it is easier to review the structure in the formula bar.