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?

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" wrote:

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?

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" wrote:

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" wrote:

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?