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.