coliervile
02-08-2007, 03:34 PM
I had come acrossed this workbook sometime ago on VBAEXPRESS and I can't understand part of this formula: =IF(COUNTIF(PTO!$B$13:$IV$13,Stats!G232)>0,"PTO",IF(COUNTIF(Holidays!$B$13:$IV$13,Stats!G232)>0,"Holiday",IF(VLOOKUP($A234,Schedules!$A$15:$H$22,G$1,FALSE)="Off","Off",IF(VLOOKUP($A234,Schedules!$A$15:$H$22,G$1,FALSE)="7a",CONCATENATE("7a-",$K234),CONCATENATE(VLOOKUP($A234,Schedules!$A$15:$H$22,G$1,FALSE),"-",Stats!$L234)))))
I understand what the formula does upto this part: CONCATENATE("7a-",$K234),CONCATENATE(VLOOKUP($A234,Schedules!$A$15:$H$22,G$1,FALSE),"-",Stats!$L234)))))
I can't understand what CONCATENATE is doing and how the cells in column K and L tie into it?????
Attached is a copy of the original file and would greatly appreciate it if someone could help me understand what CONCATENATE is doing in this particular formula. :bug:
Regards,
Charlie
I understand what the formula does upto this part: CONCATENATE("7a-",$K234),CONCATENATE(VLOOKUP($A234,Schedules!$A$15:$H$22,G$1,FALSE),"-",Stats!$L234)))))
I can't understand what CONCATENATE is doing and how the cells in column K and L tie into it?????
Attached is a copy of the original file and would greatly appreciate it if someone could help me understand what CONCATENATE is doing in this particular formula. :bug:
Regards,
Charlie