SEARCH Fails To Return All Data

[Logit]

The attached Excel worksheet outlines a simple search method. The coding is located in cells: B4, C4 & D4. Entering a search string into B2 and pressing enter activates the search function. Dilemma: The search function is not returning all possible data. Example: in B2 enter the search string "VK9" (NO QUOTES) and press enter. The returned data includes only two possibilities, when there should be a total of six. Cells D368 - D373 reflect the search function has located the six possible data items, but only two are being displayed above. I'm at a lost of what to do at this point - I'm stumped.

Please help. Thanks !

[The_Snook]

Attachment?

[FDibbins]

looks like you forgot to attach the file?

Check for leading/trailing spaces?

[The_Snook]

Hi Logit,

If you extend the ascending number range in column A (i.e. A6 = 3 etc) it pulls in the six possibilities you were expecting.

Regards,

Snook

[FDibbins]

Here is another way to do this...
For the helper column...
=COUNTIF($E$4:E4,"*"&$B$2&"*")
copied down

For the extract...
=IFERROR(INDEX(E:E,MATCH(ROW(A1),F:F,0)),"")
copied down

[Logit]

BEAUTIFUL ! Its always the simplest things that are overlooked. Thank you !

[FDibbins]

Happy to help