Is vlookup able to find the file refering to column's header? I need to get
data to column B. Formula below shows that source file has the same name as
column B just without extention (.xls). Now the formula should recognize B1
to find source file. Any help is much appreciated.
A B
1 Komax40-1must 05-03-05
2 0-1000 0
3 1001 - 2000 0
4 2001 - 3000 0

=VLOOKUP(A2,'[Komax40-1must 05-03-05.xls]DAILY SHT
Komax40-1must'!$A$9:$BL$25,64,FALSE)

Regards,
veljo