Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training courses london - HLook up formulas
|
|
|
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. |
microsoft excel training courses london - HLook up formulas
Resolved · Low Priority · Version Standard
Reply Wed 4 Apr 2007, 13:43Delegate Kamila said...
Kamila has attended:
Excel Advanced course
HLook up formulas
could you please let me know how it works? Thanks
For upcoming training course dates see: Pricing & availability
RE: HLook up formulas
Hi Kamila,
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
|