Lookup problem want 2 or more results

[Guest]

Hi, I have this list;
customer id invoice no.
300100 123
300100 456
300200 654

My question is; which invoices do customer 300100 have?
I want answer; no. 123 and 456.
How can I use Lookup to give me this result?

 

[Roger Govier]

Hi

You could mark your data and choose Data>Filter>Autofilter
Use dropdown on Customer ID and you will see a filtered list of their
Invoice numbers.