=VLOOKUP(10,INDIRECT("your_long_path!D"&P5&":F"&Q5 ),3)

The above requires the source book to be open simultaneously to work by
virtue of using INDIRECT. And if the source book is open, the longish path
would then be removed, only the book & sheet refs remains, viz. the
expression would be more like:

=VLOOKUP(10,
INDIRECT("'[08-23-08 PRODRPT.XLS]CFPRODRPT082608'!"&P5&":F"&Q5),3)

I'd just go with EditReplaces if I need to work with closed source books
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---