Solve : Use cell value as text string in formula?

1.	Solve : Use cell value as text string in formula?
Answer» Hi, Here is a formula =VLOOKUP($D$13,'C:\Users\Lynx\Google Drive\mpppm\mpppmP\t2mpppmP\[Modul_Offline_BM_T3.xls]PRESTASI UJIAN PENGGAL'!$C$12:$F$500,4,FALSE) I wish to use a cell VALUE (SAY the cell C2 shall have "T1" or "T2" or "T3") as text STING in the formula above Can be [Modul_Offline_BM_T3.xls] or [Modul_Offline_BM_T2.xls] or [Modul_Offline_BM_T1.xls] BASED on the value in cell C2 Your help much appreciated.

Discussion