I have two tables. One has a list of names, the other has a list of order
numbers with Customer IDs (we'll call them names for the example). IF I enter
a Customer ID (name) in column A, then column B should show the closed orders
for that customer along with the order number.

cola colb colc
Name1 Order#1 Closed
Name1 Order#2 Closed
Name2 Order#3 Open
Name2 Order#1 Closed
Name4 Order#1 Open

Result would be in ColB on another sheet when I type in the Customer ID in
column A as follows
ColA Colb
Name1 Order#1, Order#2
Name2 Order#3
Name3 --customer not found--
Name4 --no closed orders--