98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Lookup tables
excel training course - Lookup tables
Resolved · Low Priority · Version Standard
Ranbir has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Lookup tables
What is the difference between vlookup, hlookup and lookup functions
RE: lookup tables
Vlookup looks up a value in the first COLUMN of information vertically.
Hlookup looks up a value in the first ROW of information horisontally
Lookup returns a value either from a one-row or one-column range or from an array. The LOOKUP function has two syntax forms: vector and array. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range. The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array.
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:Adding multiple rows in an Excel 2010 WorksheetIf you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. |