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
trouble with (complicated) vlookup searching another workbook 2
VLOOKUP source values are a formula result. Getting #N/A 7
Getting rid of VLOOKUP N/A 3
Eliminate #N/A in Vlookup formulas 2
VLOOKUP returning #N/A 5
Excel 2007 - VLOOKUP always returns #N/A 4
getting #N/A when vlookup is a negative number 3

Top