PC Review


Reply
Thread Tools Rate Thread

Data validation between workbooks

 
 
ChairMan
Guest
Posts: n/a
 
      24th Nov 2008
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamic link to external workbooks through data validation MrBlades Microsoft Excel Misc 0 13th Aug 2008 12:11 AM
Copy/ move selected data from workbooks to seperate worksheets or workbooks Positive Microsoft Excel Worksheet Functions 1 30th Aug 2007 04:54 PM
Data Validation over 2 workbooks? =?Utf-8?B?QXNpYWdlZWs=?= Microsoft Excel New Users 0 2nd Jul 2007 02:40 PM
Data Validation between open Workbooks =?Utf-8?B?Y2FsZG9n?= Microsoft Excel Programming 1 4th Dec 2005 01:51 PM
When pasting data into a column with data validation I lose validation check Brad Microsoft Excel Misc 5 17th Apr 2004 01:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:32 AM.