Reply to thread

Message: [QUOTE="M@DG33K, post: 3298117"] Hi All, I'm trying to use a cell value as part of a vlookup function. The idea is to keep changing the lookup query based on a the contents of a specific cell This is the forumla I'm currently using VLOOKUP($A2,'C:\Matrix0203\07-Feb03\[025-MainPub-ET-1801.XLS]Sheet1'!$A$1:$M$200,2,FALSE) I need a way to replace "025-MainPub-ET-1801.XLS" in the formula based on another cell, where this will be generated (or manually entered). Right now I'm doing a select all, find and replace to achieve this. Any help will be appreciated... Chirag [/QUOTE]