How to use an IF, ISNA, and MATCH Function in Excel.
Learn how to use an IF and MATCH function paired with ISNA to determine where there's a match and produce either a 0 or 1 if a match is found.
In this video, we go over a question posted on Reddit. To read the original post, go here: / enter_1_if_idd_text_is...
Download the spreadsheet and follow along: docs.google.com/spreadsheets/...
Chapters:
00:00 - Intro
00:10 - Reviewing the Question on Reddit
02:55 - Brief Explanation of the Functions Used
03:20 - Applying the If, ISNA, and Match Function
05:45 - Overview of the Product
06:35 - Outro
#IF #ISNA #MATCH #Excel #functions
How to use an IF, ISNA, and MATCH