Help with creating new list off another list

[Rodney2485]

Trying to pull the Delivery # for all the Customers in the list in Column J

This formula doesnt appear to be working in any fashion, tried a few others and i'm not making any progress.

=UNIQUE(FILTER('OB Summary'!B:B,'OB Summary'!L:L="DONALDSON"))

[#2]

@Rodney2485 Not sure what you haven mind. The "OB Summary" sheet is empty in the file you attached.

[#3]

Updated file.

Sorry for attaching the wrong one.

[#4]

@Rodney2485 

I this better?

=UNIQUE(FILTER('OB Summary'!B:B, ISNUMBER(SEARCH("DONALDSON", 'OB Summary'!L:L))))

[#5]

That'll pick up the Donaldson, but I'd like to grab every Customer in that list.

[#6]

@Rodney2485 

So you want to copy the OB Summary data to Sheet1? Copy/Paste should do that.

[#7]

No, I only want to pick up the matching customers from Column J

In this case it would be Donaldson and Pak Rite.
I'm dealing with a list with 1000's of rows and 100's of customers, but I only want to grab a certain specific few.

[#8]

@Rodney2485 

My apologies - I didn't notice column J.

See the attached version.

[#9]

Last thing, in the event there's no return, to avoid a CALC error I tried throwing a =IF(ISNUMBER(ROWS(filtered),"No Records")) at the end but not making progress.

[#10 · Accepted solution]

@Rodney2485 

Use IFERROR:

=IFERROR(CHOOSECOLS(FILTER('OB Summary'!B2:Z1000, BYROW('OB Summary'!L2:L1000, LAMBDA(r, OR(ISNUMBER(XMATCH($J$1:$J$11&"*", r, 2)))))), 1, 2, 4, 11, 14, 6, 8, 20), "")

[#11]

Of course! Thank you!