Example of a detailed step in Excel in function lookup query function usage

Example of a detailed step in the lookup lookup function usage in Excel, a function works by looking for the first argument (typically a cell value) in the second argument (a range, typically a column), and when you find the first argument that is greater than the first, the function returns the upper position found, and the value of the third parameter.

If the second argument is in ascending order, it can be said to return the maximum value less than or equal to the first argument.

In general, the second argument needs to be sorted in ascending order, and the function has practical significance.

Method/Step

The inside of the red frame is the size model of the different height range.

Enter =lookup () in the cell shown in the red box, and when the cursor flashes outside the parentheses, the mouse points inside the parentheses, where the cursor flashes inside the parentheses.

At this point the cursor is flashing inside, the formula bar appears below the function parameter prompt box, here prompts the function to have two kinds of structure, one is the vector type which contains three parameters, one is contains the two parameter the array type, here we want to continue the demonstration with the vector type.

After the cursor flashes inside the parentheses, select the F2 cell in the red box with the mouse, and enter a half-width comma.

Enter the half corner comma, with the left mouse button to live N3 cell don't let go, drag down to the N9 cell, that is, select the area of the height range, and then enter a half-width comma.

After you have entered the half-width comma, click the P3 cell again and drag down to the P9 cell, which is the area of several models

Click the position after the first comma in the function bracket, then press the mouse to drag to the back bracket before, then press F4 to know the letters and numbers before the dollar sign.

After the dollar sign, click the check mark, or enter to complete the function input.

Drag the fill handle down to fill the formula, at which point the return value of the function is the size of the row's height.

The above is in Excel function Lookup query function Usage Detailed steps example, hope can be helpful to everybody!