WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to use Lookup and Reference functions in WPS Office Excel

February 25, 2022
3.9K Views

Welcome to WPS Official Academy to check the contents of how to use Lookup and Reference functions in WPS Office Excel. You're sure to become a specialist in Excelafter reading this collection involving introduction to the Lookup and Reference functions in WPS Office Excel and concerning examples in practice.

lWhat are Lookup and Reference functions in WPS Office Excel?

The Lookup&Reference function is a category among Excel built-in functions. These functions help you work with arrays of data and find the matching values, largely improving your work efficiency.

In this collection, a few often used functions are introduced, including the LOOKUP, HLOOKUP, VLOOKUP, INDEX, MATCH, and ROW functions.

lA shortcut collection of Lookup and Reference functions in WPS Office Excel

1. LOOKUP Function

The LOOKUP function is commonly used when we look up a value in a column or row.

To explore the specified use of LOOKUP function, please click to check:

LOOKUP Function in Excel | WPS Office Quick Tutorials Online

2. HLOOKUP Function

The HLOOKUP function can look up a value in a table arranged horizontally.

Click to check the details:

HLOOKUP Function in Excel | WPS Office Quick Tutorials Online

3. VLOOKUP Function

The VLOOKUP function is used to search a value in a table organized vertically.

Click to check more specific contents:

How to use the VLOOKUP function across multiple sheets in WPS Office Excel? | WPS Office Quick Tutorials Online

4. INDEX Function

The INDEX function can look up a value based on its location in the table.

To be more visualized, please click to check the video tutorial:

The INDEX function | WPS Academy Free Office Courses

5. MATCH Function

The MATCH Function helps get the position of a lookup value in which row and column.

Click to check the details:

MATCH Function in Excel | WPS Office Quick Tutorials Online

6. ROW Function

To get the row number of a reference, we can use the ROW function.

To check more visualized details, please click to check the video tutorial:

Use the ROW function in WPS Spreadsheets for row numbering | WPS Academy Free Office Courses

Under the guide of these tutorials, you are able to master how to use Lookup and Reference functions in WPS Office Excel. Did you get it?

Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.