search funtion
 

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

search funtion
 

=OR(ISNUMBER(SEARCH("4",B2:B10)))

entered with ctrl + shift & enter


--

Regards,

Peo Sjoblom


"steve" wrote in message
...
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

search funtion
 

perfect....but what's the deal with the ctrl+shift+enter....i never saw that
before


"Peo Sjoblom" wrote:

=OR(ISNUMBER(SEARCH("4",B2:B10)))

entered with ctrl + shift & enter


--

Regards,

Peo Sjoblom


"steve" wrote in message
...
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

search funtion
 

Look in help for array formulas


--

Regards,

Peo Sjoblom


"steve" wrote in message
...
perfect....but what's the deal with the ctrl+shift+enter....i never saw
that
before


"Peo Sjoblom" wrote:

=OR(ISNUMBER(SEARCH("4",B2:B10)))

entered with ctrl + shift & enter


--

Regards,

Peo Sjoblom


"steve" wrote in message
...
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