Excel Question: combining columns from different sheets

[almegaAkil]

here is the formula I use to combine date columns from two sheets in the same workbook.

=IF('TD8 sd7AL'!A30>0,(IF(ISNA(VLOOKUP('TD8 sd7AL'!A30,'TD6 sd7AL'!A30:A274,1)),'TD8 sd7AL'!A30,VLOOKUP('TD8 sd7AL'!A30,'TD6 sd7AL'!A30:A274,1))),NA())


It works for two columns but when I add a date to the middle of one of the column it doesn't work

help please!!

 

[SkipVought]

Hi,

What do you mean by, "...but when I add a date to the middle of one of the column it doesn't work"

Please post an example.

Skip,

[red]Be advised:[/red] Alcohol and Calculus do not mix!
If you drink, don't derive!

Want to get great answers to your Tek-Tips questions? Have a look at FAQ222-2244