hi,
I have a file that has (for simplicity) 5 columns: Dept, Class, Style,
Color, Units Ordered

The Units Ordered column should be a formula to a file named C:\Deptxx, with
the xx being a two-digit dept number (e.g. C:\dept10, C:\dept12, C:\dept15
etc)

so based on the two digits keyed in column 1 (Dept) the Units ordered column
should be a vlookup to file C:\deptxx. so if someone typed 10 for dept
number the formula is smart enough to look in c:\dept10.

do i do some concatanation to get this done or is there a better way?
Thanks in advance for any help!
Tami