Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » HLOOKUP
Hello Philip
Thank you for your question and welcome to the forum.
An Hlookup is similar to a Vlookup except that rather than looking vertically down the data range and selecting columns across it looks horizontally and then selects the row.
I've attached an example with an hlookup formula so you can see how it works.
Amanda
You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
hlookup eg.xls