Retrieve Multiple Values Horizontally Using Partial Match

[M_Leigh]

Hi All,

I know this is a fairly common topic, but I'm still having trouble.

My table:
Column A) Account ID
Column B) Account Name
Column M) Parent ID

Using partial account name, I need to retrieve all values in Column M that match. I'd like the output to populate horizontally in separate columns.

I was using =VLOOKUP(PARTIALNAME&"*",$B$2:$M$42000,12,FALSE), but this does not work when there are multiple values in M or if there is a single value not listed first in the lookup.

Thank you in advance.

 

[M_Leigh]

Yep, you were right. The formula wasn't arrayed. Thank you for your help!

 

[AhoyNC]

Good always like the easy fix. Thanks for the feedback.