I'm trying to use use vlookup to access another excelsheet on a network drive.
Currently I have a vlookup that works fine
However I cannot seem exhange the
H:\ with the server address
I need to link to the network address, since other users do not necessary have H-drive mapped to the same server as I do.
Anyone can help me out?