|
Excel: Work Smarter
Now that you have a name for the reference list, you
can use that name in a the HLookup formula.
1: Use the HLookup Function
Go to the Completed spreadsheet.
Select: cell A3.
Go to the Formulas Ribbon
Select: Lookup and References Click on
HLookup. 2. Fill
in the Arguments
Lookup_value: A2
Table_array: Conditions
Row_index_num: 2 Formula -> Lookup
and References ->HLookup |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.5. Look up data using a formula.
3.5.1. Using VLOOKUP and HLOOKUP: Use HLOOKUP to locate values associated with an exact match (TRUE)