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

TRIM Data Cleanse

Automatic Series and Custom Lists

Date functions

Build a PivotTable from a Data Model in Power Pivot

MATCH Function

VLOOKUP Range Lookup Table with Absolute References

$6.99 AUD

$9.99

Includes: