referring to sheet in another file

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

Tami

my question is below, i'm re-asking as i was unable to make it work even with
the other file open...but maybe my formula is incorrect.
can you elaborate on what the formula would look like?


Don's Response:
Indirect can, IF the other file is OPEN
 
ALWAYS stay in the ORIGINAL thread for responses. ALWAYS!!!

=VLOOKUP(E14,INDIRECT("'[book2]"&D14&"'!$A$2:$D$9"),2,0)
where d14 contains the tab title such as 89
or
=VLOOKUP(E15,INDIRECT("'[book2]"&ROW(A89)&"'!$A$2:$D$9"),2,0)
 
Back
Top