Excel Forum



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.