Excel Forum
Similar Content
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...
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...
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 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.