I have a file that has a sheet/tab for each department e.g. 85,86,87,88 etc.
and each tab has sales info for all the items in that dept.

In another file i have an item (dept#, class, style, etc) and want to look
up the sales info in the other file....but my lookup formula must know which
sheet to look on.

INDIRECT function doesn't work as it can't do external file references,
correct?
thx.