Home  >  Article  >  Topics  >  How to use functions to reference data in Excel?

How to use functions to reference data in Excel?

coldplay.xixi
coldplay.xixiOriginal
2020-07-07 15:59:3626460browse

How to use functions to reference data in Excel: First click [Formula-Insert Function], select [Find and Apply] in [Or Select Category]; then select the [hlookup] function and set the parameters ;Finally fill in the formula.

How to use functions to reference data in Excel?

How to use functions to reference data in Excel:

1. Open an instance file. For example: the sales summary table quotes the data in the price table.

How to use functions to reference data in Excel?

2. Select cell c9, click , and click .

How to use functions to reference data in Excel?

#3. In the pop-up dialog box, select "Or Select Category" and select "Find and Apply" from the drop-down list.

How to use functions to reference data in Excel?

4. Select the "hlookup" function in the "Select Function" list and click .

How to use functions to reference data in Excel?

#5. Click the "lookup_value" parameter text box and click the collapse button on the right.

How to use functions to reference data in Excel?

#6. Return to the worksheet and left-click the "a9" cell.

How to use functions to reference data in Excel?

7. Click the fold button again to return to the dialog box. In the same way, set the next parameter "table_array" to the cell range of "b2:F4".

How to use functions to reference data in Excel?

8. Return to the dialog box. Enter the parameter "2" in the "row_index_num" text box. Enter the logical value "false" in the "range_lookup" text box and click .

How to use functions to reference data in Excel?

9. Select cell c9 in the returned work list. Select the "b2:b4" parameter in the edit bar, click on the keyboard to add an absolute symbol to the parameter, and press the key on the keyboard to return to the worksheet.

How to use functions to reference data in Excel?

10. Select cell d9 and enter "=d9*c9" and press the key on the keyboard.

How to use functions to reference data in Excel?

11. Select the c9:d9 cell range and use the fill handle to fill in the formula downwards. The operation of referencing the data is complete.

How to use functions to reference data in Excel?

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to use functions to reference data in Excel?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:How to multiply in excel?Next article:How to multiply in excel?