Exam 77-882: Microsoft Excel 2010 Core 5. Applying Formulas and Functions 5.1. Create formulas: HLookup 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.