Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.

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.