Try it with your table reference as $A:$P rather than $1:$65536. Not
sure why you have the HYPERLINK in A1, but you need the full path if
the file is not open (although you seem to have missed an apostrophe).

Hope this helps.

Pete

On Aug 14, 3:14*pm, beeblemonster
wrote:
I'ver tried it a couple of ways...

It says #NAME? when I dothis...

This is what C3's code looks like...
=VLOOKUP(A3,INDIRECT(A1),15)

and this is what A1's looks like...
=HYPERLINK('[file name]Sheet 1'!$1:$65536)

when I change A1 to \\folder\folder\folder\[file name]Sheet 1'!$1:$65536
it come with a #REF! error



"Pete_UK" wrote:
Post the formula(s) that you have tried, and tell us what error
message you are getting.

Pete

On Aug 13, 10:00 pm, beeblemonster
wrote:
It's not working at all....
would it have something to do with the fact that both files aren't on my
hardrive... they are on a company server in password protected folder?

I've been trying to get this to work for hours... with and without it open. :(- Hide quoted text -

- Show quoted text -