Linking Techniques in Depth in Excel
Roman Kondratiuk
90:00
$198.99 $148.99AUD
HLOOKUP matches data to a lookup table by row and can be used for:
– matching approximate pre-defined ranges; e.g. match levels of bonuses to sales achieved; or
– exact data matches between data sets; e.g. employee ID to specific salary
The lookup table in a lookup formula can either have absolute cell references or can be a named range.
This is just a spacing
Highlights
- Demonstrate the 4 part syntax of a HLOOKUP function
- Match employee ID to specific salary
- Apply exact match technique
- Use a named range lookup table
This is just a spacing
This is just a spacing
Related Courses
This is just a spacing
This is just a spacing