VLOOKUP - Referencing seperate workbook getting #N/A erros

R

Reddo

I use the VLOOKUP function frequently where I link to a seperate workbook.
I've never had to have the source file open for the vlookup to work, but
recently, if the source workbook is not opened the function returns #N/A.
Once I open the source it works fine. I didn't change anything and don't know
why this started happening. Maybe I unknowingly changed a setting. Any help?
 
X

xlmate

from what I know, if you have move the source file, it will return #N/A
check that the source file is at the same location when you create the formula

hope this can help

cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP issue with #N/A - linked workbook 3
VLOOKUP Looking In Different Workbook Confusion 6
Getting rid of VLOOKUP N/A 3
Using VLOOKUP when referencing data from Access 2
VLOOKUP returning #N/A 5
Eliminate #N/A in Vlookup formulas 2
Vlookup returns #N/A correctly...but... 5
Excel 2007 - VLOOKUP always returns #N/A 4

Top