Function Help!
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? |
All times are GMT +1. The time now is 11:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com