- Picture and text skills
- Case
Returns the value in a vector or array. The LOOKUP function has two syntax forms: vector and array.
Tip: The values of LOOKUP_vector must be sorted in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE;
Otherwise, the function LOOKUP cannot return the correct result. The text is not case sensitive.
1. Vector form
A vector is a range containing only one row or column.
The vector form of the LOOKUP function searches for values in a single row or column range (vector).
Then returns the value at the same position in the second single-row range or single-column range.
If you need to specify a range that contains the value to be found, you can use this form of the LOOKUP function.
Another form of the LOOKUP function automaticallyfinds a value in the first column or row.
SyntaxLOOKUP(lookup_value,lookup_vector,result_vector)
Lookup_value is the value that the function LOOKUP is looking for in the first vector.
lookup_value can be a number, text, a logical value, or a name or reference containing a value.
Lookup_vector is a range that contains only one row or one column. The value of lookup_vector can be text, number, or logical value.
Result_vector is a range that contains only one row or one column and must be the same size as lookup_vector.
Description■ If the function LOOKUP cannot find the lookup_value, it searches for the largest value in the lookup_vector that is less than or equal to the lookup_value. Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/miao-yong-LOOKUP-han-shuo-shuo-ju-cha-zhao-yu-yin-yong-ji-qiao.html
■ < /span>If lookup_value is small
评论列表(196条)
测试