excel if in list code example Example: excel check if in list =IF(ISNUMBER(MATCH(B2,A:A,0)),1,0) B2 is value to be looked up A:A is list Range