IF Find Formula with Multiple Condition

1. IF Find Formula with Multiple Condition

Hi friends

I have attached the example worksheet. I want to find the specific text from a cell and if that's true, it should return the store name as mentioned in the formula. For some reason, it only works with first condition.

Thanks for your time and support.

2. Re: IF Find Formula with Multiple Condition

Try changing the formula to this;
Formula:
`Please Login or Register  to view this content.`

3. Re: IF Find Formula with Multiple Condition

The first IF statement throws up a #VALUE error in A3, and Excel can't get past that, so you would have to use IFERROR around each IF statement and concatenate the results with &.

Or you could use this:

=LOOKUP(LEFT(B2,FIND(" ",B2)-1),{"D&G","Gucci"},{"D&G","Gucci"})

Make sure the lookup array is in alphabetical order.

4. Re: IF Find Formula with Multiple Condition

or:

=IFERROR(LOOKUP(1000,SEARCH({"Gucci","D&G"},B2),{"Gucci","D&G"}),"")

5. Re: IF Find Formula with Multiple Condition

Thanks a lot all..It works perfect..

6. Re: IF Find Formula with Multiple Condition

Thanks Glen....What does "1000" refers to in above Lookup formula?

7. Re: IF Find Formula with Multiple Condition

or
=INDEX({"D&G","Gucci"},MATCH(1,COUNTIF(B2,{"D&G","Gucci"}&" *"),0))

8. Re: IF Find Formula with Multiple Condition

Hi. Firstly, thanks for the rep. 1000 is an (arbitrary) large number. SEARCH returns the position in the string of the first letter of Gucci (if present) or D&G (if present). Otherwise it returns an error. So, in your example it will return a 1 if Guccis is present. Lookup then looks for an exact match for 1000. there isn't one. If the LOOKUP function can not find an exact match, it chooses the largest value in the lookup range that is less than or equal to the value of 1000.

9. Re: IF Find Formula with Multiple Condition

That makes sense now to me..Thanks again for your explanation...

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

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1