Index with partial text

[rbacon100]

Hi all. I am having a big problem and I cant find solution.

I need index match formula with 3 criteria.

2 criterias are dates and 3rd is partial text.

So basically I need to lookup partial text and between dates...

So for example.

Cell is Apple.

I need to lookup "App" in column but with dates too.

Now I know how to index match multiply criteria but partial text is problem.

I cant able to figure it out how to add partial text with another criteria

I hope someone can help me

 

[rbacon100]

I cannot give you specific formula with the information you have provided.. But you would likely be using the SUMPRODUCT function to test for your three criteria; when you test for the partial text, the argument might be something like (isnumber(search("app*",range)))

Hi there... Thanks for reply

=INDEX(C4:H1159,MATCH(1,(C4:C1159>A2)*(D41159<B2)*(D41159=c2),0),6)this is just example. So here are 3 criterias. First 2 are ok but i need third part (D41159=c2) that is looking partial text in range. So for example if c2 is app. And in d4:d1159 has apple in it, or big apples or something like that, that retrives that number.