This one's a little tricky:

I have two sheets. The first sheet contains the below data:

Cust# Cust Name Date Notes
1 A 8/1/06 Slow Payor
2 B 8/1/06 Premier Customer
3 C 8/1/06 Avg. Customer
1 A 9/1/06 Avg. Payor
1 A 10/1/06 Slow Payor

I'd like to be able to enter the customer number somewhere in sheet2 and
have it return all corresponding dates and notes for the specified cust# (I
would assume separate formulas for the dates/notes). So, if I enter Cust# 1,
it should return:

8/1/06 Slow Payor
9/1/06 Avg Payor
10/1/06 Slow Payor

Any thoughts?