Thread: match help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default match help

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