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

[ June 18, 2018 ] Excel Magic Trick 1401 Excel Is Fun
[ June 17, 2018 ] Highline Excel 2016 Class 23 Excel Is Fun
[ June 16, 2018 ] Highline Excel 2016 Class 22 Excel Is Fun
[ June 15, 2018 ] Excel Magic Trick 1400 Excel Is Fun
[ June 14, 2018 ] Excel Magic Trick 1399 Excel Is Fun
[ June 13, 2018 ] Excel Magic Trick 1398 Excel Is Fun
[ June 12, 2018 ] Excel Magic Trick 1397 Excel Is Fun
[ June 11, 2018 ] Excel Magic Trick 1396 Excel Is Fun
[ June 10, 2018 ] Highline Excel 2016 Class 21 Excel Is Fun
[ June 9, 2018 ] Highline Excel 2016 Class 20 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