Hi Jim. Well this one of those where you have a good number of options. Good
for you. Depending on the goal you are persuing, I would probably change the
option. So here are some suggestions.

You can use:
1- Vlookup
2- Hlookup

Although you can build some more complex functions to get the same result,
these two are the easiest ones. Also, again depending on the purpose, you can
use Pivot Tables. Best of luck.


"Jim" wrote:

Following is a sheet where I enter data:
1 2 3 4 5 6
7
Date Acct # Scheduled Actual 101 111 325
11/4/2008 6744-08 11/4/2008 11/4/2008
11/5/2008 6744-09 11/4/2008 11/4/2008 1 2 2
11/5/2008 6744-10 11/4/2008 11/4/2008 1 2 1
11/6/2008 6744-11 11/4/2008 11/4/2008 2 2 1
11/7/2008 6744-12 11/4/2008 11/4/2008 1 8 1

I will have a second sheet where I will change the date and would like to
match and pull over data based on the date:

For example if I put in 11/5/2008 I would like to match the entries. but
the bigger question is what formula is needed to read from row to row?

Date
11/5/2008
Account number 101 325 30001


Thanks for the help