98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup and Hlookup
Vlookup and Hlookup
Resolved · Low Priority · Version 2003
Wed 15 Oct 2008, 16:41Delegate Barnaby said...
Barnaby has attended:
Excel Intermediate course
Vlookup and Hlookup
What is the purpose behind Vlookup and Hlookup
Thu 16 Oct 2008, 11:53Trainer Amanda said...
RE: Vlookup and Hlookup
Hi Barnaby
Thank you for your question and welcome to the forum.
VLOOKUP and HLOOKUP functions are designed to get Excel to extract a certain piece of information from a list/database in Excel.
Basically VLOOKUP is used to get Excel to search for something in the left most column of a table, then find a corresponding piece of data from the same row and display it for you.
HLOOKUP is used to get Excel to search for something in the top row of a table, then find a corresponding piece of data from the same column and display it for you.
I hope this helps.
Amanda
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. |
Excel tip:Keyboard Shortcuts to Add Rows or ColumnsCouple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns. |
