Hi All

Is it possible to embed a variable file name inside the =MATCH() function?

Example:

=MATCH(A1,CONCATENATE("C:\",B1,".XSL#SHEET1.C1:C5000"),0)

where A1 is text I am looking for
where B1 is a cell containing the external root file name string, such as "010305".

The idea is that each B(n) cell may contain a different file name, so need to handle the variable in the function call.

Any ideas?

TIA

Dom