HLOOKUP Exact Match Lookup Table with Named Range
Roman Kondratiuk
5:44
$9.99 $6.99AUD
VLOOKUP matches data to a lookup table by column 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 VLOOKUP function
- Match levels of bonuses to sales achieved for a group of sales persons
- Apply 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