Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions |