help with format inserting referenced value

E

elrussell

Joined
Jan 30, 2006
Messages
1
Reaction score
0
Hi - this works just fine for one named sheet in the other workbook:

=INDEX([x.xls]BranfordBowen!$A$1:$C$7, MATCH("Discussion Questions",[x.xls]BranfordBowen!$A$1:$A$7,), MATCH("(EDTC/560-
MABJ01IJF3)",[x.xls]BranfordBowen!$A$1:$C$1,))

I have one workbook reading another workbook. What I need to do is modify this function to accept a referenced cell's content. The function is currently hand-coded to read a sheet named "BranfordBowen" (for example) but I need it to accept the contents of a cell that has the name of another worksheet "FredSmith", for example.

Thanks in advance!
 

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

index/match 3
UNABLE to conditional format CSE formulas cells 1
Set non-continuous PrintArea via Function / Name 0
Display formula with values referenced 3
External reference not working 1
Indexing Sheets in Referenced Workbook within formula 1
referencing a 3D Named Range 3
COUNTIF + ADDRESS Issue 1

Back
Top