The search function only lets you look in one cell.

Why can't you use: search(4,B2:B10)

is there something that can just tell me if there is a 4 in that range? I
dont want to use vlookup, i just need to know if it is true or false