Can I do lookup in different XLS spreadsheet?
Posted by Rick Koenig on March 10, 2001 12:13 PM
I want to do a lookup and add values based on data in my current worksheet by looking up entries in a separately-maintained spreadsheet. Is that possible with Vlookup or one of the variants? All I've read seems to say the data MUST be in the current worksheet. But if I have a long list of 500 or so values, then I first have to get them from somewhere and PASTE them into the spreadsheet. (Or can *that* be automated with a macro?)
What I want is pretty simple. Take a value from a cell, look up that value externally, return another value that's in the external table (or text file) into my present worksheet. Is it really SO HARD to do a simple function like that?