How to create

X

xirx

Hi!

I want to access data from another Excel-File. The name
of according file is the concatenation of "data" and the
(text-) value in Column A.

This works...

A B
-- -----------------------------------------------------------
01 =index('[file01]data'!$A$A; match(...,'[file01]data'!$B$B))
02 =index('[file02]data'!$A$A; match(...,'[file02]data'!$B$B))
03 =index('[file03]data'!$A$A; match(...,'[file03]data'!$B$B))
04 =index('[file04]data'!$A$A; match(...,'[file04]data'!$B$B))

.... but I would like to replace the text-constants in the index
and match functions and let Excel calulate these. However, if
I try e.g.

=index(concatenate("'[file";A1;"]data'!$A$A; ...

the result of the concatenate yields a string indentically to what
I entered before, but Excel obviously handels a (computed) string
differently then manually entered text.

Questions:

(a) How to solve this probelm?

(b) Is there something like an EVAL in LISP or PERL that interprets
computed text (e.g. result of a concatenate) as it would have been
enteredd manually?

Thanks for your help!
 
Top