Video 00076 Key difference between FIND and MATCH excel functions when used in array @MySpreadsheetLab
Video 00076 Key difference between FIND and MATCH excel functions when used in array @MySpreadsheetLab
Uploaded January 2014 | Updated September 2026, 10 minutes ago
Get Excel file 00076 here: http://1drv.ms/1bYwrTa

Some normal Excel functions can be used in array formulas but it takes research and practice to use them properly.
Watch this video to see how to use Excel's FIND and MATCH functions inside of an array formula.
Note the key difference between them.

Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com
Video 00076 Key difference between FIND and MATCH excel functions when used in arrayVideo 00043 Formulas_Array Formulas_Example1_LEN_functionVideo 00024 Intro_Working with DATE and TIME_in ExcelVideo 00065 Customized and Sorted Data Validation List_Step 2Video 00003 Intro_Excel2010_RIBBON00162 Excel Formula Calculates Value of Chess Pieces00166 Count Groups Above or Below TargetsVideo 00105 MOD and QUOTIENT functionsVideo 00111 2nd Data Val List Greater Than 1st Data Val ListVideo 00093 Is merged cell with formula a good idea?00146 Step by Step Instruction Check Box ToggleVideo 00120 Is the solution benefit worth the cost
Kevin Lehrbass |

Video 00076 Key difference between FIND and MATCH excel functions when used in array

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER