Excel Forum
Similar Content
OR Function - Check if Any Argument is True
Tutorial: The OR function in Excel checks if ANY argument in it evaluates to TRUE.  If anything eva...
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
Macro: This free Excel macro filters data to display results that end with certain words, text, o...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick #245: Matching 2 Lists w IF & OR functions


Check to see if values in one list are in another list with the IF and OR functions in a simple array formula. See how to use the IF and OR functions in a simple array formula that shows WINNER in cell if two lotto numbers are the same.





Got a Question? Ask it Here in the Forum.