wps lookup command

1. WPS Lookup command?

In the WPS table, the LOOKUP function is used to search for a specific value in the specified area and return the matching value. The specific steps to use this function are as follows: first, select the cell where you want to enter the function; then, enter LOOKUP in the function bar; next, enter the value you want to find; then, enter the area you want to search; finally, determine the search method and Just press the Enter key. In this way, the WPS form will automatically search and return matching values ​​in the specified area.

Solution:

To help you better use the LOOKUP function, the following is its syntax: LOOKUP(lookup_value, lookup_vector, result_vector). Its function is to find matching items in the lookup_vector based on the lookup_value and return the value in the corresponding result_vector. Hope this concise explanation helps you.

1. (1) lookup_value: The value to be looked up in lookup_vector.
2. (2) lookup_vector: A range or array containing the value to be searched.
3. (3) result_vector: A range or array containing the value to be returned.

Example:

=LOOKUP(A2, A5:A10, B5:B10)

This formula will find the value of cell A2 in A5:A10 and return the value of the corresponding location B5:B10 area.

2. What does the RANK value in the table function refer to the logical value mean? how to use?

In the table function, the numerical reference logical value of the RANK function refers to the parameter how to handle when the values ​​are the same. In WPS tables, the RANK function is used to determine the relative ranking of a value within a given range. The specific usage is as follows:

Solution:

The syntax of the RANK function is: RANK(number, ref, order)

1. (1 ) number: The numerical value to determine the ranking.
2. (2) ref: Contains the set of values ​​in which the ranking is to be determined.
3. (3) order: A logical value used to specify the order of ranking. If TRUE, the ranking is in ascending order; if FALSE, the ranking is in descending order.

Example:

=RANK(B2, B5:B10, TRUE)

This formula will determine the ranking of the value of cell B2 in the range of B5:B10, in ascending order.

3. Summary

1. (1) WPS Lookup command: In the WPS table, the LOOKUP function is used to Finds a specific value in a specified range and returns the matching value. Its syntax is LOOKUP(lookup_value, lookup_vector, result_vector), which can be used to quickly search and extract data.

2. (2) The RANK value in the table function refers to a logical value: The RANK function is used to determine the relative ranking of a value within a given range. The numerical reference logical value is a parameter used to specify the ranking order. TRUE means ranking in ascending order, FALSE means ranking in descending order. You can rank values ​​as desired and specify a ranking order based on logical values.

The above is the detailed content of wps lookup command. For more information, please follow other related articles on the PHP Chinese website!