Connect to a Data Source in Power Pivot
Roman Kondratiuk
4:48
$9.99 $6.99AUD
Description
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
LESSON HIGHLIGHTS
- Demonstrate the 4 part syntax of a HLOOKUP function
- Match levels of bonuses to sales achieved for a group of sales persons
- Use approximate or range match techniques
- Use absolute references with a lookup table
This is just a spacing
This is just a spacing
Related Courses
This is just a spacing
This is just a spacing