G
Guest
Hi
I have a workbook that contains several accounts on individual sheets and a sheet that contains a summary of the entire workbook. What I am having problems with is creating a formula that will match the dates on the summary page vs. the dates on each individual accounts, and then when it finds a match (i.e. 12/1/03 = 12/1/03) it will copy a value for that match (i.e if 12/1/03 on the summary sheet = 12/1/03 on the individual sheet, then the blank cell will = a value from the individual account for that date).
If the dates don't match (if 12/31/03 doesn't match c1 from the individual account), I want it to continue searching until it finds a match and copy the value listed for that date (have the formula look at c2, c3, ... on the sub sheet)
I tried a nested if statement, but I found that very confusing to setup.
Any help would be great! Thanks
Steve
I have a workbook that contains several accounts on individual sheets and a sheet that contains a summary of the entire workbook. What I am having problems with is creating a formula that will match the dates on the summary page vs. the dates on each individual accounts, and then when it finds a match (i.e. 12/1/03 = 12/1/03) it will copy a value for that match (i.e if 12/1/03 on the summary sheet = 12/1/03 on the individual sheet, then the blank cell will = a value from the individual account for that date).
If the dates don't match (if 12/31/03 doesn't match c1 from the individual account), I want it to continue searching until it finds a match and copy the value listed for that date (have the formula look at c2, c3, ... on the sub sheet)
I tried a nested if statement, but I found that very confusing to setup.
Any help would be great! Thanks
Steve