Data validation between workbooks

C

ChairMan

I am having some trouble using data validation between workbooks. I am trying
to pass this formula through data validation:
=indirect(vlookup(A1,GradeLookup,2,0)).

I have created named ranges(with the same names) in both workbooks. I have
also created a lookup range in the source file called "GradeLookup". I
cannot get the lookup function to work correctly. I know that I can us a
Vlookup in the same workbook, but can I use this function between workbooks?

If I hardcode one of the ranges output file (data validation) it passes the
correct information, so I think that the problem is the Vlookup.

I have refered to the Contextures website. However, I cannot find the
answer to my question.

Thanks in advance!
 

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 & Data Validation 0
Using Data Validation with a vlookup formula 3
Data Validation List 1
Data Validation "The Source Currently Contains an Error" 0
How to fix Compatibility error 3
dynamic link to external workbooks through data validation 0
Using Data Validation in a Table 0
Data Validation help 5

Top