Vlookup referencing a workbook on a network drive

[alpfeiffer]

I am trying to lookup a value in a workbook contained on a network drive, but I am getting an invalid address on the G:\extrustion\newinventoryinfo.xls.

The function is:

=VLOOKUP(A4,[G:\extrusion\newinventoryinfo.xls]!$C$2:$D$43,2,FALSE)

Thanks.

Al Pfeiffer

 

[Domski]

I think you've got you're square brackets in the wrong place and you've got no worksheet reference.

The format should be like this:

=VLOOKUP(A1,'F:\files\[test.xls]Sheet1'!$A$2:$B$4,2,FALSE)