Hello,

I have a database of 175 workbooks in different subfolder, I have to make a
single sheet (summary sheet) for main figures in every workbook.

For this I have to write formula for every workbook seperately to call the
value.

I am looking for a way so the workbook path or hyperlink to every individual
workbook can be use as table array, what I am trying is as follows

In Cell E2 : 'S:\Automobile Assembler\Atlas Honda\Internal Research\[JUNE
Time Series Data ATLH.xls]Time Series'!$A$1:$FF$220
In Cell F2: 'S:\Automobile Assembler\Atlas Honda\Internal Research\[JUNE
Time Series Data ATLH.xls]Time Series'!$A$1:$A$220

In Cell B2: BVPS Basic (Column Heading)

In Cell C2: where value is required, formula is

=INDEX(HYPERLINK(E2),MATCH(B2,HYPERLINK(F2),0),14)

The Formula return #Value! error, whether entered as array or simple

Help needed please.