About HLOOKUP Tool
For tables laid out sideways — with field names down the first column and records across. Match values across rows and bring back the rows you need.
How to use HLOOKUP Tool
- Upload the main and lookup tables (horizontal layout).
- Pick the match row and the rows to return.
- Run the lookup and download the result in the same horizontal layout.
Limitations
- Everything runs in your browser’s memory, so the practical file size depends on your device. As a rough guide: up to ~50 MB or ~500,000 rows works well on a modern laptop; phones and tablets handle much less.
- Very large files can make the tab slow or crash. If that happens, split the file first or use a desktop computer.
- Outputs keep values and formulas’ results but not formatting, charts, images, pivot tables or macros.
Frequently asked questions
What is a horizontal table?
One where each record is a column and each field is a row.
Can I switch to vertical?
Yes, change “Table orientation” at any time.
Is the result transposed?
No, it is returned in the same horizontal layout as your input.
Disclaimer: Excel Tools by gumber.ai is a hobby project and is completely free to use. It is provided “as is”, without warranty of any kind. Always double-check results before relying on them, and keep a copy of your original files.
Related tools
Compare Excel Files
Spot changed cells, added rows and removed rows between two versions of a sheet.
Remove Duplicates
Find and remove duplicate rows based on all columns or just the ones you pick.
Excel VLOOKUP
Pull matching values from a second table into your sheet — no formulas, no #REF errors.
XLOOKUP / INDEX-MATCH
Look up any column in any direction and return one or many result columns.