vlookup error
 

i have this formula
=IF(ISNA(VLOOKUP(A2,'\\Malcolmp\shared\My Documents\[Share
Recommendations.xls]Portfolio'!$A$6:$J$67,10,FALSE)),"""",
VLOOKUP(A2,'\\Malcolmp\shared\My Documents\[Share
Recommendations.xls]'Portfolio'!$A$6:$J$67,10,FALSE))

i cant see what is wrong with it but i get an error based on
\\Malcolmp\shared\My in the 2nd line
much appreciated if anyone can help

for some reason i dont get the error if i have the filepath pointing to a
document on my hard drive rather than elsewhere onthe server.

"Micayla Bergen" wrote:

i have this formula
=IF(ISNA(VLOOKUP(A2,'\\Malcolmp\shared\My Documents\[Share
Recommendations.xls]Portfolio'!$A$6:$J$67,10,FALSE)),"""",
VLOOKUP(A2,'\\Malcolmp\shared\My Documents\[Share
Recommendations.xls]'Portfolio'!$A$6:$J$67,10,FALSE))

i cant see what is wrong with it but i get an error based on
\\Malcolmp\shared\My in the 2nd line
much appreciated if anyone can help

There is an extra ' before Portfolio in the 2nd occurance. Might just be a
message typo. Might be the problem.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Micayla Bergen" wrote in message
...
for some reason i dont get the error if i have the filepath pointing to a
document on my hard drive rather than elsewhere onthe server.

"Micayla Bergen" wrote:

i have this formula
=IF(ISNA(VLOOKUP(A2,'\\Malcolmp\shared\My Documents\[Share
Recommendations.xls]Portfolio'!$A$6:$J$67,10,FALSE)),"""",
VLOOKUP(A2,'\\Malcolmp\shared\My Documents\[Share
Recommendations.xls]'Portfolio'!$A$6:$J$67,10,FALSE))

i cant see what is wrong with it but i get an error based on
\\Malcolmp\shared\My in the 2nd line
much appreciated if anyone can help