Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hlookups
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Hlookups
Resolved · Low Priority · Version 2003
Reply Tue 6 May 2008, 16:59Delegate Jillian said...
For upcoming training course dates see: Pricing & availability
RE: hlookups
Hi Jillian,
The H lookup or horizontal lookup searches for a value in the top row of a table, and then returns a value in the same column from a row you specify in the table. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.
For example if you used
=HLOOKUP("Training",A1:D4,4) goes across the first row and looks up the word Training, and it returns the value from row 4 that's in the same column. So in effect it goes across and then down.
Hope that helps
Tracy
|