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
Bookmarks