Partial matches for a teext string being used to search an array

[Brycicle]

Hi,

With the help of Excel Forum, the array formula below successfully finds matches to a text string from within the array:

{=SMALL(IF((Data!$A$1:$I$304=$A$2)*(Data!$A$1:$I$304<>""),ROW(Data!$A$1:$I$304)),ROW(1:1))}

There is one proviso, the IF function used in the array formula, will only find matches where the string exactly matches the entire contents of one or more cells in the array

I need some assistance please, to work out how to successfully find matches for a string that is only part of the contents of one or more cells

I have attached a copy of my Workbook.

Regards Bryce

[Tsjallie]

Try this formula

Please Login or Register  to view this content.

Notice that the formula will return the same row number for each exact or partial match.