your VLOOKUP() doesn't refer to a second file, but a sheet named [4]baru within the same document, which in turn is an invalid sheet name, since sheet names may not contain the characters [ ] * ? : / \ or the character ' (apostrophe) as first or last character. This clearly explains why you got a #NAME? error.
VLOOKUP(D8,'file:///<path_to_your_secondfile>'#$<sheetname>.$B$1:$I$65255,8,0 PS: The ! separating sheetname from range makes me assume, that you got the formula from an Excel document. Hello your VLOOKUP() doesn't refer to a second file, but a sheet named [4]baru within the same document, which in turn is an invalid sheet name, since sheet names may not contain the characters [ ] * ? : / \ or the character ' ' (apostrophe) as first or last character. This clearly explains why you got a #NAME? error. I'd expect something like VLOOKUP(D8,'file:///<path_to_your_secondfile>'#$<sheetname>.$B$1:$I$65255,8,0
PS: The ! separating sheetname from range makes me assume, that you got the formula from an Excel document.