Function Help!

B

BBohannon

I need a function that refereces according to specific value.
For example:
A B
1 Job #=0451 Reference=='[BG-1.orig.0451.xls]BG-1p1'!$F$34
2 Job #=0452 Reference=='[BG-1.orig.0452.xls]BG-1p1'!$F$34

Any suggestions?
 
D

Duke Carey

This requires that the referenced files are open:

=INDIRECT("'[BG-1.orig."&a1&".xls]BG-1p1'!$F$34")

If having the referenced files open is an issue, do a search on the Excel
NGs you will find referneces to a custom function called (I think)
INDIRECT.EXT() that is a subsitute for INDIRECT() and doesn't require the
files to be open.
 
B

BBohannon

Okay, You've got me on the right track. I will need to use the INDIRECT.EXT.
I have downloaded it. Where do I nee to put it in my program files so that
it works.

Duke Carey said:
This requires that the referenced files are open:

=INDIRECT("'[BG-1.orig."&a1&".xls]BG-1p1'!$F$34")

If having the referenced files open is an issue, do a search on the Excel
NGs you will find referneces to a custom function called (I think)
INDIRECT.EXT() that is a subsitute for INDIRECT() and doesn't require the
files to be open.


BBohannon said:
I need a function that refereces according to specific value.
For example:
A B
1 Job #=0451 Reference=='[BG-1.orig.0451.xls]BG-1p1'!$F$34
2 Job #=0452 Reference=='[BG-1.orig.0452.xls]BG-1p1'!$F$34

Any suggestions?
Click to expand...
Click to expand...
 
Top