# If, ISNUMBER, SEARCH Question! Help!

1. ## If, ISNUMBER, SEARCH Question! Help!

Hello everyone!

Had a question. I am trying to create a formula that allows me to search for MULTIPLE specific text within a column and have it spit out the appropriate information: Here is my issue.
Col A Col B
Size Zone
160x600 MBT-Mortgage-160x600
MBT_BankDeals-300x600
MBT_Banking-300x250

What I am trying to do is create an if statement that will look for the size within Column B (Zone) and spit out the appropriate size! I attempted to create it with the following formula:
=IF(ISNUMBER(SEARCH("160x600",E2)),"160x600", "Neither")

The problem is this only helps me locate ONE of the sizes (160x600). I need the formula to be able to identify all three sizes at the same time!(300x250,300x600) Is it a matter of using the OR statement within the IF formula?

M

2. ## Re: If, ISNUMBER, SEARCH Question! Help!

=IFERROR(LOOKUP(2,1/ISNUMBER(SEARCH({"160x600";"300x250";"300x600"},E2)),{"160x600";"300x250";"300x600"}),"NEITHER")

OR

``Please Login or Register  to view this content.``

3. ## Re: If, ISNUMBER, SEARCH Question! Help!

DAFFODIL11 For the WIN!!! Thank you so much!!!

Now if I wanted to add more values to that formula (i tried and it didnt work), what do I need to do?

For example, in addition to the three I listed above I need to add : 728x90 and 300x50.

I tried to mimic the other sizes but for some reason it did not work!

Thanks again!!!!

M

4. ## Re: If, ISNUMBER, SEARCH Question! Help!

The first of the two formulas is probably easier to adjust. Just put a semicolon and quotes between each, and then list it again in the second half.

=IFERROR(LOOKUP(2,1/ISNUMBER(SEARCH({"160x600";"300x250";"300x600";"728x90";"300x50"},E2)),{"160x600";"300x250";"300x600";"728x90";"300x50"}),"NEITHER")

And here's the 2nd:

``Please Login or Register  to view this content.``

5. ## Re: If, ISNUMBER, SEARCH Question! Help!

THANK YOU SO MUCH!! You saved me!

I would buy you a shot if I could!!!

M

6. ## Re: If, ISNUMBER, SEARCH Question! Help!

I'll have one tonight in my honor.

There are currently 1 users browsing this thread. (0 members and 1 guests)