How to use functions to reference data in Excel?

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:

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

2. Select cell c9, click , and click .

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

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

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

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

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".

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 .

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.

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

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.

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!