Nobody's laughing. We all started somewhere and with time we all will
be better. Everyone here is learning every day. That's what makes
these forums so valuable. Even the people that consider themselves
experts or guru's, I am quite sure, learn something these forums.


This would be my version with the Round Function added:

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

But, I did note that you seem to be referencing another workbook. Is
that so, or do you want to reference another sheet within the same
workbook. In other words, is Terms.xls another workbook or is Terms
another sheet in your current workbook.

If it is another sheet then, delete the .xls from Term.xls at all
occurrences:

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

If it is another workbook, then put square brackets around the workbook
name, and you will still need to add a sheet name after that, for
example: (Note: you will need to replace Sheet1 with the actual sheet
tab name in the Terms book)

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

By the way, if you want 1 decimal place, just replace the last 0 in the
formula with a 1.

Excel has good examples of all its functions in the help files. This
is a good place to start for basic functionality of the functions. The
forum will help with using those basic functions to do some truly
extraordinary things.


Let me know and good luck.


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