Hangout: How to Use the HLOOKUP Function in Excel Technique: How to Use the HLOOKUP Function in Excel | Why: Look up a value in a row based on the column heading | Step 1: Create your formula with the HLOOKUP function Buy $4.99