VLOOKUP Exact Match Lookup Table with Named Range

No reviews yet.

Lookup functions can rapidly and easily perform a multitude of tedious data matching tasks e.g. highlighting data mis-matches and anomalies between large tables; matching salaries to employees; awarding bonuses according to sales volumes, and mapping values from different sources into consolidated reports.

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.

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

Duration: 5mins 38secs

$6.99 AUD

from

$9.99

Add to Cart

Includes:

Quality On-demand Video Demonstrations
Step-by-step Learner Guide
Demonstration and practice exercises to boost retention
Lifetime access
Course progress indicator

VLOOKUP Exact Match Lookup Table with Named Range

Highlights

Related Courses

Lookup Function Essentials in Excel

Create and Use Calculated Columns in Power Pivot

Count Functions

PivotTable Essentials for Data Analytics in Excel

Add go to The Power Pivot window Command To QAT

Concatenate Data in Power Pivot

$6.99 AUD

$9.99

Includes: