Function Help!

[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?

[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.


"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?

[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" 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?