Hi,
I am having trouble using the external references as range arguments in
excel 2007. I was wondering if maybe someone could help. I am using a vlookup
to look at a phone numbers database (worksheet) and lookup the corresponding
name given a phone number. It works fine with local ranges but i tried to
extend the functionality of it by having the phonedatabase workbook separate
from the other workbooks. This way, i can refer to the database range in
vlookup and have different workbooks for different employees that can all
reference the same database of numbers. i can get it to work if the workbook
is open but not when the phone database workbook is closed. if it is closed
it will only work if i use a direct reference to the external range. if i try
to use indirect it does not work. Any suggestions? I am trying to use an
indirect from vlookup to reference a cell in the phone database workbook that
contains the current region (full path) of the phone database table (making
it more extensible as i add and remove numbers) i also tried the indirect
statement locally to a string reference to the external range.
Thank you for any help you can give.

Preston