Excel Forum



Excel Magic Trick #119: Is Item In List? 2 Examples


See how to determine if a particular item is in a list of items using two formulas: ISNUMBER & MATCH function formula & COUNTIF function formula. These tricks are from Aladin at the Mr Excel Message Board and djquackquack at YouTube.





Got a Question? Ask it Here in the Forum.