What do you have in A3? Does it actually match with something in
column A of the external file? The way your VLOOKUP formula is set up,
the data in the external file needs to be sorted on column A, and if
A3 is empty or smaller than the first value then you will get an
error. You might like to look for an exact match, by changing your
formula to:

=VLOOKUP(A3,INDIRECT(A$1),15,0)

and then the data doesn't have to be sorted.

Hope this helps.

Pete

On Aug 14, 6:26*pm, beeblemonster
wrote:
no. File name and Sheet 1 are replacements of what I have. I can't really
send that information out. But sheet 1 is replaced by the name of my first
tab and file name is exactly as the file name is. [bla bla bla (Updated
aug08).xls]



"Glenn" wrote:
beeblemonster wrote:
It's still not working.
The file being called upon is open behind it. I have '[file name.xls]sheet
1'!$A:$X in A1. and C3 is showing... #REF! with =VLOOKUP(A3,INDIRECT(A$1),15)
as the code.

I can't find the mistake anywhere...

Does A1 actually say "file name" and "sheet 1", or did you substitute the file
name and sheet name you actually are trying to reference.- Hide quoted text -

- Show quoted text -