LOOKUP in WPS on Windows: Introduction

WPS LOOKUP is a lookup and reference function in WPS Office AirSheet on Windows; it includes 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	All current tasks are available directly

About This Feature

Overview

LOOKUP is a built-in function in WPS Office AirSheet on Windows. It is used to find a matching value in a single row, a single column, or an array range and return the corresponding result from the matched position. It fits common spreadsheet lookup tasks such as price mapping, grade conversion, and cross-sheet references.

Core capabilities include:

Enter the LOOKUP formula and complete a basic lookup calculation.
Fill in arguments with syntax prompts and finish formula editing more efficiently.
Reference data across worksheets or inside nested formulas.
Update calculation results automatically after data changes and manually recalculate when needed.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local formula calculation does not require a network connection; downloading, installation, and account-related actions require network access
Other	You need to be able to open an AirSheet file and edit cells and the formula bar

Download & Installation

Before using LOOKUP, install WPS Office on your Windows device and open AirSheet.

Item	Notes
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office → Open AirSheet → Select any cell and confirm that you can type `=LOOKUP(` in the formula bar

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports entering the LOOKUP function in AirSheet, with syntax prompts, cross-sheet references, and automatic recalculation.	Excel provides LOOKUP in vector form and array form to search a single row or column and return a result from the corresponding position.	Google Sheets supports `LOOKUP(search_key, search_range\|search_result_array, [result_range])` and requires sorted lookup data for proper results.	Notion formulas can calculate with database properties, built-ins, and functions, but they are not traditional spreadsheet cell lookup functions.	Acrobat supports calculation fields in PDF forms, which fit form calculations rather than spreadsheet lookup functions.
WPS Advantages	Advantage: You can start a lookup directly by entering LOOKUP in a spreadsheet cell. Distinct: Formula bar prompts support everyday spreadsheet lookup and result checking.	Compared with WPS: The official page emphasizes vector and array forms and notes that other lookup functions may be preferred in some cases.	Compared with WPS: It also supports LOOKUP, but the official page emphasizes sorted ranges and suggests related functions when data is not sorted.	Compared with WPS: It is better suited to database property calculations and automation logic than cell-based lookup formulas.	Compared with WPS: It focuses on PDF form field calculations, so the usage scenario differs from spreadsheet lookup work.
Official Source	—	LOOKUP function	LOOKUP	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion

If your work focuses on spreadsheet lookup, argument entry, and linked results, WPS LOOKUP handles these common tasks directly in AirSheet. Compared with database formula tools or PDF form calculation tools, it is closer to everyday spreadsheet work. Compared with other spreadsheet products, the usage pattern is also familiar for users moving existing formulas.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Product price mapping	Sales teams, procurement staff	The item code is known, but the price needs to be returned quickly	Use LOOKUP to search the item code column and return the matching price
2	Grade conversion	Teachers, academic staff	Multiple score ranges make manual judgment error-prone	Build a sorted reference table and use LOOKUP to return the grade
3	Cross-sheet references	Finance teams, operations staff	Data is spread across worksheets, and manual copying can shift values	Reference another worksheet range inside the formula
4	Result verification	Data coordinators	It is hard to confirm whether formulas refreshed after source data changed	Change the source data, check automatic updates, and recalculate if needed

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Basic LOOKUP function usage	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF, AI, and extended tools	Some features are limited	More features are available
Cloud storage	1 GB	20 GB, based on the pricing page

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Everyday spreadsheet lookup and basic formula editing	Free plan	Basic LOOKUP usage does not require membership and fits routine data work
More cloud storage or broader office features are also needed	WPS membership	Fits users who need more supporting features across different work scenarios

WPS membership center: Subscribe now