Sorry,

Try:

=ROUND(CONCATENATE("*Of these,
",ROUND(VLOOKUP($A$2,Terms.xls!$A$6:$D$23,3),0 ),"
(",ROUND((VLOOKUP($A$2,Terms.xls!$A$6:$D$23,3)/C12)*100,0),"%)"," have
been employed for more than 2 years, compared with
",ROUND(VLOOKUP("total",Terms.xls!$A$6:$D$23,3),0) ,"
(",ROUND((VLOOKUP("total",Terms.xls!$A$6:$D$23, 3)/E12)*100,0),"%),","
at the department."),0)


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489964