Greetings,

Is it possible to use VLOOKUP to transfer data from one workbook to
another?

TIA

-Minitman

Yes, it is certainly possible. Try something like

=VLOOKUP("a",'Sheet2'!A1:B10,2,FALSE)

The single quotes around the sheet name are not required unless
the sheet name contains a space, but it never hurts to include
them.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Minitman" wrote in message
...
Greetings,

Is it possible to use VLOOKUP to transfer data from one
workbook to
another?

TIA

-Minitman

Hey Chip,

I just realized the subject says worksheet and the body refers to
workbook. I need to transfer from one workbook to another workbook.

Let's say that the data is in C:\Data\Cust1.xls in a sheet called
"List" and a named range called "CustList1" ('List'!A1:F10). If the
VLOOKUP is in C:\Data\Schedule.xls on a sheet called 'Daily' looking
to column D Rows 2:100 which have data validation as the Lookup_value.

If the Vlookup is in F5 and the validation is in D5, would the formula
look something like this:

=VLOOKUP(D5,C:\Data\Cust1.xls"CustList1",2,FALSE)

I'm not sure about the syntax for the workbook reference, what do you
think?

-Minitman





On Tue, 13 Sep 2005 12:21:14 -0500, "Chip Pearson"
wrote:

Yes, it is certainly possible. Try something like

=VLOOKUP("a",'Sheet2'!A1:B10,2,FALSE)

The single quotes around the sheet name are not required unless
the sheet name contains a space, but it never hurts to include
them.

Open both workbooks, but let excel do the heavy lifting.

Start your formula:
=vlookup(d5,
then use window to go to the other workbook.
select your worksheet
select the range
and finish up (with ,2,false) )

Close that other workbook and you'll see the syntax.

Minitman wrote:

Hey Chip,

I just realized the subject says worksheet and the body refers to
workbook. I need to transfer from one workbook to another workbook.

Let's say that the data is in C:\Data\Cust1.xls in a sheet called
"List" and a named range called "CustList1" ('List'!A1:F10). If the
VLOOKUP is in C:\Data\Schedule.xls on a sheet called 'Daily' looking
to column D Rows 2:100 which have data validation as the Lookup_value.

If the Vlookup is in F5 and the validation is in D5, would the formula
look something like this:

=VLOOKUP(D5,C:\Data\Cust1.xls"CustList1",2,FALSE)

I'm not sure about the syntax for the workbook reference, what do you
think?

-Minitman

On Tue, 13 Sep 2005 12:21:14 -0500, "Chip Pearson"
wrote:

Yes, it is certainly possible. Try something like

=VLOOKUP("a",'Sheet2'!A1:B10,2,FALSE)

The single quotes around the sheet name are not required unless
the sheet name contains a space, but it never hurts to include
them.

--

Dave Peterson

Hey Dave,

That is exactly what I was looking for - Thank you.

-Minitman

On Tue, 13 Sep 2005 13:46:22 -0500, Dave Peterson
wrote:

Open both workbooks, but let excel do the heavy lifting.

Start your formula:
=vlookup(d5,
then use window to go to the other workbook.
select your worksheet
select the range
and finish up (with ,2,false) )

Close that other workbook and you'll see the syntax.

Minitman wrote:

Hey Chip,

I just realized the subject says worksheet and the body refers to
workbook. I need to transfer from one workbook to another workbook.

Let's say that the data is in C:\Data\Cust1.xls in a sheet called
"List" and a named range called "CustList1" ('List'!A1:F10). If the
VLOOKUP is in C:\Data\Schedule.xls on a sheet called 'Daily' looking
to column D Rows 2:100 which have data validation as the Lookup_value.

If the Vlookup is in F5 and the validation is in D5, would the formula
look something like this:

=VLOOKUP(D5,C:\Data\Cust1.xls"CustList1",2,FALSE)

I'm not sure about the syntax for the workbook reference, what do you
think?

-Minitman

On Tue, 13 Sep 2005 12:21:14 -0500, "Chip Pearson"
wrote:

Yes, it is certainly possible. Try something like

=VLOOKUP("a",'Sheet2'!A1:B10,2,FALSE)

The single quotes around the sheet name are not required unless
the sheet name contains a space, but it never hurts to include
them.

As Chip said or use a defined name such as

mylookuptable

--
Don Guillett
SalesAid Software

"Minitman" wrote in message
...
Greetings,

Is it possible to use VLOOKUP to transfer data from one workbook to
another?

TIA

-Minitman

Hey Don,

Thanks for the reply and confirmation.

I am now looking for the syntax to do just that, any suggestions?

-Minitman



On Tue, 13 Sep 2005 13:07:38 -0500, "Don Guillett"
wrote:

As Chip said or use a defined name such as

mylookuptable

Just highlight your table and name it or define a name if you will add to
it.
=vlookup(2,mylookuptable,2,0)

--
Don Guillett
SalesAid Software

"Minitman" wrote in message
...
Hey Don,

Thanks for the reply and confirmation.

I am now looking for the syntax to do just that, any suggestions?

-Minitman



On Tue, 13 Sep 2005 13:07:38 -0500, "Don Guillett"
wrote:

As Chip said or use a defined name such as

mylookuptable

Hey Don,

Thanks, that helps.

Sorry I didn't reply sooner, I had eye surgery last week and am just
now getting to the point where I can see somewhat. They had to
reattach my retina (second time, hope it stays this time).

-Minitman



On Wed, 14 Sep 2005 07:13:55 -0500, "Don Guillett"
wrote:

Just highlight your table and name it or define a name if you will add to
it.
=vlookup(2,mylookuptable,2,0)

glad you can see and glad to help. Should I make the font LARGER?

--
Don Guillett
SalesAid Software

"Minitman" wrote in message
...
Hey Don,

Thanks, that helps.

Sorry I didn't reply sooner, I had eye surgery last week and am just
now getting to the point where I can see somewhat. They had to
reattach my retina (second time, hope it stays this time).

-Minitman



On Wed, 14 Sep 2005 07:13:55 -0500, "Don Guillett"
wrote:

Just highlight your table and name it or define a name if you will add to
it.
=vlookup(2,mylookuptable,2,0)