Excel Magic Trick 1464: Is Item In List? Formula to Check if Item is in a List on Separate Sheet.

Download Files: http://ift.tt/2wcZVBU
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to check whether or not an item in is a list using the MATCH Function. Learn three different formula that may work for your situation:
1. (00:11) Introduction
2. (00:53) Excel New Windows & Arrange All features to show different sheets in same workbook on screen at same time.
3. (02:54) Formula #1 to check whether item is in a list using MATCH and ISNUMBER functions.
4. (06:14) Formula #2 to check whether item is NOT in a list using MATCH and ISNA functions.
5. (07:13) Formula #3 to check whether item is in a list using IF and MATCH and ISNUMBER functions. This formula puts the text “Found” or “Not Found” in cell.
6. (08:30) Conclusion

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.