Formerly Best Training
© 2024 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
Forum home » Delegate support and help forum » Microsoft Excel Training and help » HLOOKUP
Resolved · Low Priority · Version 2003
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
|
Excel tip:Printing spreadsheets without opening them firstHere's a fast way of printing a spreadsheet from Windows Explorer/My Computer. |
We'll call during UK business hours
Server loaded in 0.11 secs.