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

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 this equation to 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!