When using a vlookup I know that if I have a customer name multiple times the vlookup will only give of the values and multiple times.

I have a list of customers who may or may not be listed multiple times and I need to look that list up to another worksheet that will list payments for those customers and they may be listed once or multiple times. I need the look up to bring up all of the payments but individually and if I am looking up the same customer 4 times but there are only 3 payments then on the forth line id like it to say 0 or indicate no further payments.

Example:
EXCEL QUESTION.jpg

SO ID LIKE TO GET THE PAYMENTS TO SHOW UP NEXT TO EACH CUSTOMER (IF ANY) ON WORKSHEET ONE.

I HAVE ATTACHED MY EXAMPLES.

THANK YOU!!