HLOOKUP 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.

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.

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

Duration: 5mins 44secs

$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

HLOOKUP Exact Match Lookup Table with Named Range

Highlights

Related Courses

Add go to The Power Pivot window Command To QAT

Copy and Move Formulas and Functions

Slicers in Power Pivot

Concatenation – combine data from multiple cells

If Function Nested

Add Chart Elements

$6.99 AUD

$9.99

Includes: