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 microsoft - Lookup table
excel training microsoft - Lookup table
Resolved · Low Priority · Version Standard
Folusade has attended:
Excel Intermediate course
Excel Advanced course
Lookup table
How do I use a lookup table
RE: How to use Lookup
Hi Folusade,
Thanks for your question.
There are 2 lookup functions: VLOOKUP & HLOOKUP. Depending on whether your data list is lined up Vertically (VLOOKUP) or Horizontally (HLOOKUP).
Both are used to find a record from a large table.
For example, a 3-column table range from "A8" to "C20" stores Employee Info across column A to C with headings:
Employee No, Dept & Salary.
You can find info on a particular employee, using VLOOKUP.
=VLOOKUP (search cell address, data table range, result column number, match type)
In a sample scenario:
Set cell "A6" as search cell with employee no "E012"
Set data table between "A8 to C20"
Lookup the salary of employee No. "E012" - 3rd column of the data table
Matching exact Employee No.
The function will be as follows:
=VLOOKUP ("A6", "A8:C20", 3, false)
The answer will return the salary figure of employee "E012"
Regards,
Katie
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:Hide data in Excel WorksheetsLet's say you have some data in cell 'C5' you would like to hide from the casual viewer. |