How to fix the search range of vlookup function vlookup function to fix the search range shortcut key

The vlookup function is a commonly used vertical search function in Excel, but I don’t know how to fix the search range when using vlookup? PHP editor Xigua will answer this question. The steps for fixing the search range are as follows:

1. Add that we want to position F to C.

2. Enter =vio here in C2, and then click VLOOKUP.

3. Enter (.

4. Click A2 in front, and then enter the English symbol, .

5. Add $ before the row number and column label respectively to indicate the fetch Absolute value, so you can perform a fixed range.

6. Then enter 2, which means precise search.

7. Then enter the following bracket, and then click the drop-down cell, and you will find that it has been Fixed.

The above is the detailed content of How to fix the search range of vlookup function vlookup function to fix the search range shortcut key. For more information, please follow other related articles on the PHP Chinese website!