Channel: ExcelIsFun
Category: Education
Tags: formulas and functionsvlookuphighline collegemike girvinemtlower casefind case sensitiveexcel is funexcel magiccase sensitive lookupoffice 365filter is a lookup functionexcel functionsexcel funvlookup case sensitive lookupexcel magic trick 1772lookup based on caseexcellookup functionfilter functionmicrosoft 365 excelindex and matchexcel 365upper caseexcel formulasexcelisfunemt 1772exact function case sensitive
Description: Download Excel File: excelisfun.net/files/EMT1772.xlsx Learn how to perform Case Sensitive Lookup in Excel. 1. (00:00) Introduction 2. (00:05) Microsoft 365 Method with FILTER and EXACT functions. 3. (01:04) Any of the older versions of Excel: See Five Different formulas, including LOOKUP and FIND. 4. (01:54) Conclusion and Video Links