Exam 77-882: Microsoft Excel 2010 Core 5. Applying Formulas and Functions 5.1. Create formulas: HLookup HLookup Results The HLookup compared the data with the reference cells in the Lookup Table and determined an appropriate value.   6. Fill Down the Formula Select: Cell C2. Autofill the equation in Cells C3:C5.   The formula in Cell C5 in this example is: =HLOOKUP(B5,Terms,2)   Memo to Self: You should SAVE your work at this point...especially if the formula works!