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

[ April 24, 2018 ] Excel Magic Trick 1372 Excel Is Fun
[ April 23, 2018 ] Excel Magic Trick 1371 Excel Is Fun
[ April 15, 2018 ] Highline Excel 2016 Class 05 Excel Is Fun
[ April 14, 2018 ] Highline Excel 2016 Class 04 Excel Is Fun
[ April 13, 2018 ] Highline Excel 2016 Class 03 Excel Is Fun
[ April 12, 2018 ] Highline Excel 2016 Class 02 Excel Is Fun
[ April 11, 2018 ] Highline Excel 2016 Class 01 Excel Is Fun
[ April 10, 2018 ] Excel Magic Trick 1370 Excel Is Fun
[ April 9, 2018 ] Excel Magic Trick 1369 Excel Is Fun
[ April 8, 2018 ] Excel Magic Trick 1368 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

Master Excel

Translate »

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