Thread
:
VLOOKUP in another workbook/Access database
View Single Post
#
3
Posted to microsoft.public.excel.programming
Chris Carr[_2_]
external usenet poster
Posts: 2
VLOOKUP in another workbook/Access database
Anyway to do it with Book 2 closed?
"Tom Ogilvy" wrote:
=vlookup(A1,[Book2.xls]Sheet1!$A$1:$Z$200,2,false)
Book2 should be open.
--
Regards,
Tom Ogilvy
"Chris Carr" <Chris
wrote in message
...
First of all, forgive me if this has been covered before. But I can't
seem
to find a doable solution for me. Here's my problem:
I have a form that uses VLOOKUP to access data another sheet in the same
workbook. The problem is that the whole workbook is almost 11mb!!
I want to be able to make the user-input part be separate from all of my
data sources, thereby freeing valuable resources (i.e., I need to have 1
form
accessing 3-4 external sources).
Any help out there?
Thanks in advance.
Chris.
Reply With Quote
Chris Carr[_2_]
View Public Profile
Find all posts by Chris Carr[_2_]