Lookup & Reference Functions

Latest Posts

[ December 26, 2018 ] Excel Magic Trick 1496 Excel Is Fun
[ December 24, 2018 ] Excel Magic Trick 1495 Part 2 Excel Is Fun
[ December 23, 2018 ] Excel Magic Trick 1495 Part 1 Excel Is Fun
[ December 22, 2018 ] Excel Magic Trick 1494 Excel Is Fun
[ December 21, 2018 ] Excel Magic Trick 1493 Part 2 Excel Is Fun
[ December 20, 2018 ] Excel Magic Trick 1493 Part 1 Excel Is Fun
[ December 19, 2018 ] Excel Magic Trick 1492 Excel Is Fun
[ December 18, 2018 ] Excel Magic Trick 1491 Excel Is Fun
[ December 7, 2018 ] Excel Magic Trick 1490 Excel Is Fun
[ December 5, 2018 ] Excel Magic Trick 1489 Excel Is Fun
[ December 3, 2018 ] Excel Magic Trick 1488 Excel Is Fun
[ December 1, 2018 ] Excel VBA 1.5 Excel VBA

INDIRECT Function

WORKBOOKS

OFFSET Function

WORKBOOKS

INDEX and MATCH Functions

WORKBOOKS

INDEX Function

WORKBOOKS

MATCH Function

WORKBOOKS

CHOOSE Function

WORKBOOKS

Large Table VLOOKUP

WORKBOOKS

Nested VLOOKUP

WORKBOOKS

VLOOKUP and HLOOKUP Exact Match

WORKBOOKS

VLOOKUP and HLOOKUP Approx Match

WORKBOOKS

EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.

Translate »

Notice: Unknown: failed to delete and flush buffer. No buffer to delete or flush in Unknown on line 0

Master Excel

Welcome to Master Excel. The place to find useful tutorials for all versions of Microsoft Excel.

Lookup & Reference Functions

INDIRECT Function

OFFSET Function

INDEX and MATCH Functions

INDEX Function

MATCH Function

CHOOSE Function

Large Table VLOOKUP

Nested VLOOKUP

VLOOKUP and HLOOKUP Exact Match

VLOOKUP and HLOOKUP Approx Match