Vlookup for multiple resulf

I create a table for record who customer account outstanding.

Table sample is
A1=Date A2=Customer A3=Agent A4=Amount A5=Bill No

I wish can create both drop-down-list when i choose Customer A or Agent, i'll know all data from Customer A example who is the follow up agent, amount, date and bill no.

I create a drop-down-list and using vlookup , but vloookup only can show out one record .

mic1412 welcome to the forum

1. Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

2. Please upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.