referring to a sheet in another file

  • Thread starter Thread starter Tami
  • Start date Start date
T

Tami

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Flexible formula for linking to externa Files 2
search and copy text from one sheet to others 4
Embedded lookup 3
Match a value to multple criteria both in rows and columns 3
Dependent drop down dynamic range formula, off sheet. 7
Sumif across mutiple sheets 3
Excel Home made rota system- creating a time sheet in relation to demand 0
Indirect References - Summarizing sheets - Relative? 1

Back
Top