Problem looking up a non-exact match

[Neoptolemos]

I'm using the following formula to look up the third occurrence of the value "A2" in the "test" sheet, which could for example be "Apple pie", and then give me the value that's in the first row in that sheet. This works flawless, but I need to also make it find the occurrence of "Apple pie with coffee", so anything starting with "Apple pie" and then something after that. I'm sure there's a formula for this, I just can't seem to find it.

=IFERROR(INDEX(test!$A$2:$B$201;SMALL(IF(test!$A$2:$B$201=A2;ROW(test!$A$2:$B$201)-ROW($R$2)+1;ROW($B$201)+1);3);1); $A$99)

Thanks in advance.

[NBVC]

Try:

Please Login or Register  to view this content.

[Neoptolemos]

Brilliant, thanks.