referring to sheet in another file

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
 
D

Don Guillett

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)
 

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

Regarding Word Add in on Office 365 0
Drop down list control value in vba 2
Can't save my Office documents (after computer rebuild and reauthorization) 0
Standar deviation across sheets help 0
ASK Field Formatting 1
Many sheets, one DB? 1
referring to a sheet in another file 1
External cell reference between two excel worksheets both in One Drive 0

Top