Hello,

I'm trying to see if a given value exists in a list of values. I could use COUNTIF for this, but I also came across this formula: =OR(INDEX(A1:A3=B2,)) It works, but does anyone know why? I'm not sure why exactly the OR() is needed and why the INDEX formula is working as it is.

Any clarification is appreciated.

Thanks,
Ben