I would like to make a master list in excel for all of my other worksheets to
be able to access to save myself a bunch of typing time. Example, if i have
in my master list

Column A Column B Column C
Code Product Price
1020.100 Permit A 150.00
1020.200 Permit B 200.00

i would like to be able to simply type 1020.100 into column A and have
column's B and C filled in. Is this possible, and if it is, how do i go about
getting it set up?

One way:

Say your master list is in a worksheet named Master. Then in your
working sheet:

A1: 1020.100
B1: =VLOOKUP(A1, Master!A:C,2,FALSE)
C1: =VLOOKUP(A1, Master!A:C,3,FALSE)

In article ,
Paco3517 wrote:

I would like to make a master list in excel for all of my other worksheets to
be able to access to save myself a bunch of typing time. Example, if i have
in my master list

Column A Column B Column C
Code Product Price
1020.100 Permit A 150.00
1020.200 Permit B 200.00

i would like to be able to simply type 1020.100 into column A and have
column's B and C filled in. Is this possible, and if it is, how do i go about
getting it set up?

but will i be able to pull up the information if it is in a different
workbook and that workbook is not opened?

"JE McGimpsey" wrote:

One way:

Say your master list is in a worksheet named Master. Then in your
working sheet:

A1: 1020.100
B1: =VLOOKUP(A1, Master!A:C,2,FALSE)
C1: =VLOOKUP(A1, Master!A:C,3,FALSE)

In article ,
Paco3517 wrote:

I would like to make a master list in excel for all of my other worksheets to
be able to access to save myself a bunch of typing time. Example, if i have
in my master list

Column A Column B Column C
Code Product Price
1020.100 Permit A 150.00
1020.200 Permit B 200.00

i would like to be able to simply type 1020.100 into column A and have
column's B and C filled in. Is this possible, and if it is, how do i go about
getting it set up?

Did you try it?

In article ,
Paco3517 wrote:

but will i be able to pull up the information if it is in a different
workbook and that workbook is not opened?

Your ORIGINAL post should have mentioned another workBOOK. The easiest way
to do this is to make a defined name range in the destination workbook that
refers to the workbook/worksheet/range in the source workbook.
='[workbook.xls]sheet name'!$D$1:$F$23

--
Don Guillett
SalesAid Software

"Paco3517" wrote in message
...
but will i be able to pull up the information if it is in a different
workbook and that workbook is not opened?

"JE McGimpsey" wrote:

One way:

Say your master list is in a worksheet named Master. Then in your
working sheet:

A1: 1020.100
B1: =VLOOKUP(A1, Master!A:C,2,FALSE)
C1: =VLOOKUP(A1, Master!A:C,3,FALSE)

In article ,
Paco3517 wrote:

I would like to make a master list in excel for all of my other
worksheets to
be able to access to save myself a bunch of typing time. Example, if i
have
in my master list

Column A Column B Column C
Code Product Price
1020.100 Permit A 150.00
1020.200 Permit B 200.00

i would like to be able to simply type 1020.100 into column A and have
column's B and C filled in. Is this possible, and if it is, how do i go
about
getting it set up?

sorry, but i'm new to this so you'll have to dumb it down just a touch. i
tried doing it that way but it isn't working and i can't figure out how to
type it in correctly.

"Don Guillett" wrote:

Your ORIGINAL post should have mentioned another workBOOK. The easiest way
to do this is to make a defined name range in the destination workbook that
refers to the workbook/worksheet/range in the source workbook.
='[workbook.xls]sheet name'!$D$1:$F$23

--
Don Guillett
SalesAid Software

"Paco3517" wrote in message
...
but will i be able to pull up the information if it is in a different
workbook and that workbook is not opened?

"JE McGimpsey" wrote:

One way:

Say your master list is in a worksheet named Master. Then in your
working sheet:

A1: 1020.100
B1: =VLOOKUP(A1, Master!A:C,2,FALSE)
C1: =VLOOKUP(A1, Master!A:C,3,FALSE)

In article ,
Paco3517 wrote:

I would like to make a master list in excel for all of my other
worksheets to
be able to access to save myself a bunch of typing time. Example, if i
have
in my master list

Column A Column B Column C
Code Product Price
1020.100 Permit A 150.00
1020.200 Permit B 200.00

i would like to be able to simply type 1020.100 into column A and have
column's B and C filled in. Is this possible, and if it is, how do i go
about
getting it set up?

insertnamedefinein the name box put in a name of your choice such as
myrange1in the refers to box type in your refernce such as
='[workbook.xls]sheet name'!$D$1:$F$23

=VLOOKUP(A1, myrange1,2,0)

--
Don Guillett
SalesAid Software

"Paco3517" wrote in message
...
sorry, but i'm new to this so you'll have to dumb it down just a touch. i
tried doing it that way but it isn't working and i can't figure out how to
type it in correctly.

"Don Guillett" wrote:

Your ORIGINAL post should have mentioned another workBOOK. The easiest
way
to do this is to make a defined name range in the destination workbook
that
refers to the workbook/worksheet/range in the source workbook.
='[workbook.xls]sheet name'!$D$1:$F$23

--
Don Guillett
SalesAid Software

"Paco3517" wrote in message
...
but will i be able to pull up the information if it is in a different
workbook and that workbook is not opened?

"JE McGimpsey" wrote:

One way:

Say your master list is in a worksheet named Master. Then in your
working sheet:

A1: 1020.100
B1: =VLOOKUP(A1, Master!A:C,2,FALSE)
C1: =VLOOKUP(A1, Master!A:C,3,FALSE)

In article ,
Paco3517 wrote:

I would like to make a master list in excel for all of my other
worksheets to
be able to access to save myself a bunch of typing time. Example, if
i
have
in my master list

Column A Column B Column C
Code Product Price
1020.100 Permit A 150.00
1020.200 Permit B 200.00

i would like to be able to simply type 1020.100 into column A and
have
column's B and C filled in. Is this possible, and if it is, how do i
go
about
getting it set up?