Concatenating cells to produce a cell ref from another excel file

G

Guest

Can anyone tell me how I might combine to cells to generate a thrird cell
content which calls data from an external reference e.g. I am in wb1.xls and
I have two cells a1 and b1. c1 = a1&b1. a1 = the file name of the external
source, wb2.xls and b1 = the cell reference in wb2. This is so that i can
keep cell rfernces constant but with variable file names. the problem I have
is that I need to make this concatenated cell, c1 operate as =a1+b2 but I
only seem to be able to intorduce the = sign as text.
 
J

JE McGimpsey

If your external reference file is open, then try

=INDIRECT("[" & A1 & "]" & A2)

Where

A1: wb2.xls
A2: Sheet1!A1

INDIRECT() doesn't work on closed files.
 

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

setting cell values based on a 3rd cell 4
Excel Add ^ to a row of cells containing letters 3
Combining text from several cells into 1 cell 4
Retaining cell reference in destination, when sorting source file 3
Can a cell be turned on or off? 1
Find a cell's content in another cell but only as whole word(s) 2
Using a worksheet function to create an unusual cell reference pat 3
formula to make the value in a cell, to a row in a sum function 5

Top