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" <[email protected]> wrote in message
news:[email protected]...
> 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