Hangout: How to Use the LOOKUP Function in Excel Technique: How to Use the LOOKUP Function in Excel | Why: Look up a value in a range and return a corresponding value | Step 1: Create your formula with the LOOKUP function Buy $4.99