Index with partial text

  • Thread starter Thread starter rbacon100
  • Start date Start date
R

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
 
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)))
Click to expand...

Hi there... Thanks for reply

=INDEX(C4:H1159,MATCH(1,(C4:C1159>A2)*(D4:D1159<B2)*(D4:D1159=c2),0),6)this is just example. So here are 3 criterias. First 2 are ok but i need third part (D4:D1159=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.
 
Back
Top