excel how to check if a value is in a 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