Concatenation – combine data from multiple cells
Roman Kondratiuk
6.17
$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
- Understand the 4 part syntax of a VLOOKUP 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