Exam 77-427 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.2   Look Up Data with Functions: Use the HLOOKUP Function

Formulas -> Function Library ->Lookup and References ->HLookup HLookup Arguments Now that you have a name for the reference list, you can use that name in a formula.   5: Try This: Use the HLookup Function Select: Cell C1 and type: Net Days. Format Cell C1 BOLD, this is a label.   Select Cell C2 and create the formula: Go to Formulas-> Function Library. Go to Lookup and References. Click on HLookup.   What Do You See? Microsoft Excel will prompt you to fill in the HLOOKUP Arguments: Lookup_value: B2 Table_array: Terms Row_index_num: 2   Click on OK. Keep going, please...