Lookup & Reference Functions

Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

Latest Posts

[ August 15, 2018 ] Office 2016 15 Excel Is Fun
[ August 14, 2018 ] Office 2016 14 Excel Is Fun
[ August 13, 2018 ] Office 2016 13 Excel Is Fun
[ August 12, 2018 ] Office 2016 12 Excel Is Fun
[ August 11, 2018 ] Office 2016 11 Excel Is Fun
[ August 10, 2018 ] Excel Magic Trick 1440 Excel Is Fun
[ August 9, 2018 ] Excel Magic Trick 1439 Excel Is Fun
[ August 8, 2018 ] Excel Magic Trick 1438 Excel Is Fun
[ August 7, 2018 ] Excel Magic Trick 1437 Excel Is Fun
[ August 6, 2018 ] Excel Magic Trick 1436 Excel Is Fun

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