How to Do a VLOOKUP in Excel – Beginner Walkthrough | ComTools

Beginner-friendly walkthrough for how to do a VLOOKUP in Excel: pick lookup cell, select table, choose return column, use FALSE for exact match.

Before you start

Your lookup column must be the leftmost column in the table range. Headers are optional but keep row 1 consistent. Sort is only required for approximate match (TRUE).

Try Formula AI

Open /excel-formula-ai, pick the VLOOKUP snippet, or describe your columns in one sentence to get a custom formula.