# Index, Match of If, OR function?

1. ## Index, Match of If, OR function?

I have been struggling trying to create a formula to return TEXT based on multiple criteria.

I have 4 columns for dates titled “Promise Date”, “Delivery Date”, “Cancelled Date” and “Return Date (Columns E, F, G & H). In column “I” (titled “Delivery Status”) I wanted to return text based on:

If only Promise Date entered then returns “Pending”

If Promise Date and Delivery Date are entered, then returns “Received”

If Promise Date and Cancelled Date are entered, then returns “Cancelled"

If Promise Date, Delivery Date, and Return Date are entered then returns “Returned”

If Columns E to H do not have any data, then Column I returns a blank cell

Note: I typed in results I want in Column “I”

See attached

2. ## Re: Index, Match of If, OR function?

This should get you started:

=IF(AND(E2<>"",COUNT(E2:H2)=1),"Pending",IF(AND(E2<>"",G2<>"",COUNT(E2:H2)=2),"Cancelled",""))

You can nest the other IF statements you need between the second IF statement and the red section at the end. Make sure the number of IF statements is reflected with the same number of closing brackets at the end.

3. ## Re: Index, Match of If, OR function?

...another take on it

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

4. ## Re: Index, Match of If, OR function?

Thank you very much, AliGW!!!!!!!!

I really appreciate that you gave my a start point and explanation/direction for me to complete the formula. Here is my result:

This Forum and Members are Awesome!

5. ## Re: Index, Match of If, OR function?

Well done! I always think it feels better, ultimately, when we solve the issue ourselves. I am glad the push was sufficient.

6. ## Re: Index, Match of If, OR function?

Thank you for the quick reply, Richard!!!

I tried the formula, but a window pops up stating "You've entered too few arguments for this function"

7. ## Re: Index, Match of If, OR function?

Thank again, AliGW.

Post set to "Solved"

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