🆚 Summary of Differences Feature VLOOKUP HLOOKUP XLOOKUP Lookup direction Down (vertical) Across (horizontal) Any direction Lookup location must be First column First row Anywhere Can search left? ❌ No ❌ No ✔ Yes Can return multiple columns? ❌ ❌ ✔ Required table format Vertical only Horizontal only Any Allows reverse search ❌ ❌ ✔ […]