Microsoft Excel Look Up Functions – LOOKUP VLOOKUP HLOOKUP Online Course
Is this course right for me?
Have you started working with more data and find you can’t cross reference data easily? Have you seen others using the VLOOKUP function but have no idea how it works, or perhaps you have used it a bit but need a refresher? Then this 1 hour trainer-led session is for you.
Training course objectives:
- How the LOOKUP function works and what its limitations are
- How to write a basic VLOOKUP function to find related information within the same worksheet
- The difference between near and exact matches in your searches
- The limitations of the VLOOKUP function
- How to build a VLOOKUP function working between different worksheets and workbooks
- How to use the HLOOKUP function
Versions Available
2010
Related Training Courses in Our Range
LOOKUP function
- Putting together the LOOKUP function
- Applying the function to data
- Limitations of the LOOKUP function
VLOOKUP function
- Putting together the VLOOKUP function
- Applying it to a single data set
- Using VLOOKUP across different worksheets
- Using VLOOKUP across different workbooks
- Limitations of the VLOOKUP function
HLOOKUP function
- Putting together the HLOOKUP function
- Applying it to data
