search funtion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=OR(ISNUMBER(SEARCH("4",B2:B10)))

entered with ctrl + shift & enter
 
perfect....but what's the deal with the ctrl+shift+enter....i never saw that
before
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting 1
Need Function Help 8
vlookup Function 2
need a search/find/lookup function 4
How can I use a sheet in a formula based on the value in a cell 2
If statement based on time ranges 2
VLOOKUP with IF logic 5
Excel JUMP FROM SEARCH BAR TO RESULT 3

Back
Top