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.
I've also tried =IF(COLUMN()-2<=COUNTIF($B$2:$B$42000,PARTIALNAME&"*"),INDEX($M$2:$M$42000,MATCH(PARTIALNAME&"*",$B$2:$B$42000,0)+COLUMN()-3),"")
Thank you in advance.
Bookmarks