EXCEL FORMULA if value 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
=IF(ISNUMBER(MATCH(B2,A:A,0)),1,0)
B2 is value to be looked up
A:A is list Range