How to use the lookup function_How to use the lookup function

The function of lookup function is eye-catching and curious. The editor of PHP, Xigua, keeps abreast of the pulse of the times, and hereby provides this valuable guide to developers, analyzing the use of the lookup function in a simple and easy-to-understand manner. The following content will analyze the mechanism of the lookup function in detail, usage examples and common application scenarios to help you easily master this convenient tool.

1. Ordinary search (single condition)

Find the corresponding value based on the cell content

=LOOKUP(1,0/(B3:B11=E3), C3:C11).

2. Ordinary search (multiple conditions)

Find the corresponding value according to the target condition, and add the corresponding condition to the condition of 1

=LOOKUP(1,0/(A3:A11=E3)*(B3:B11=F3),C3:C11).

3. Find the content of the last Chinese character

Use the Chinese characters that are sorted by the first letter of the Chinese character to search, generally use the Chinese characters starting with Z to search

【Example】Find the last Chinese character content: character

=LOOKUP("在",B:B).

4. Find the last number

Use a number greater than the current search column as the search value

[Example] Find the last number content: Combat power

=LOOKUP(1000,C:C).

5. Find the last non-empty cell

Use the first ordinary search, and add [""] to the area condition, which represents any non-empty cell Cell

=LOOKUP(1,0/(C3:C13""),C3:C13).

6. Interval search

When the order of numbers is sorted, interval search can be performed

Find commission points based on performance interval

=LOOKUP(E4,B:C).

7. Search the full name based on the abbreviation

Use the formula combination with the FIND function to achieve

[Example] Search for the country of Wu by searching for the string position Sun Quan's combat power

=LOOKUP(9^9,FIND(D3,A3:A11),B3:B11).

8. Search for the abbreviation based on the full name

Also use FIND to search for strings

[Example] Find the combat effectiveness of Sun Quan of Wu Kingdom

=LOOKUP(9^9,FIND(A3:A11,D3),B3:B11).

The above is the detailed content of How to use the lookup function_How to use the lookup function. For more information, please follow other related articles on the PHP Chinese website!