6 Replies - 1720 Views - Last Post: 11 September 2012 - 12:03 PM Rate Topic: -----

#1 Keylogger  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 344
  • Joined: 14-February 11

Excel find/search multiple cells.

Posted 11 September 2012 - 11:08 AM

Hi

I have the following table in the cell A:

A |

2 |
3 |
4 |
2 |
2 |

And I need to check if there's number 2 in all cells of A (ex: A1, A2, A3..etc)
I tried so far:
=IF(FIND("2"; A1:A4; 1); "0"; "1")

But it gives me error.
Is This A Good Question/Topic? 0
  • +

Replies To: Excel find/search multiple cells.

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9572
  • View blog
  • Posts: 36,247
  • Joined: 12-June 08

Re: Excel find/search multiple cells.

Posted 11 September 2012 - 11:15 AM

Typically it's a great thing to post said error..


Over all though use the 'search' to see if you get a number or an undefined value for your cell and search term.

=ISNUMBER((SEARCH("2",B249)))

Was This Post Helpful? 0
  • +
  • -

#3 Keylogger  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 344
  • Joined: 14-February 11

Re: Excel find/search multiple cells.

Posted 11 September 2012 - 11:39 AM

That was an example. I'm not dealing with numbers. I'm dealing with text.

The error that shows is just "Error value".

Edit: If I only choose 1 cell, it works fine..but I need to find a range of cells.

This post has been edited by Keylogger: 11 September 2012 - 11:40 AM

Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9572
  • View blog
  • Posts: 36,247
  • Joined: 12-June 08

Re: Excel find/search multiple cells.

Posted 11 September 2012 - 11:44 AM

... then use the range selector with the colon...

=ISNUMBER((SEARCH("2",B248:B252)))

Was This Post Helpful? 0
  • +
  • -

#5 Keylogger  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 344
  • Joined: 14-February 11

Re: Excel find/search multiple cells.

Posted 11 September 2012 - 11:54 AM

Nope.
I want something like this:
=IF((SEARCH("Gold";D3:D5;1));"Gold Yes";"Not Gold")

Was This Post Helpful? 0
  • +
  • -

#6 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9572
  • View blog
  • Posts: 36,247
  • Joined: 12-June 08

Re: Excel find/search multiple cells.

Posted 11 September 2012 - 11:59 AM

I don't understand how to respond to that. Did you find your answer, or what? where did that chunk of code come from?
Was This Post Helpful? 0
  • +
  • -

#7 Keylogger  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 344
  • Joined: 14-February 11

Re: Excel find/search multiple cells.

Posted 11 September 2012 - 12:03 PM

I found the solution. Only I need to do was checking with function COUNTIF() firstly.

Thank you. :taz:
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1