How do I make a master look-up list in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
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 said:
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
(e-mail address removed)
Paco3517 said:
but will i be able to pull up the information if it is in a different
workbook and that workbook is not opened?
Click to expand...
Click to expand...
 
insert>name>define>in the name box put in a name of your choice such as
myrange1>in 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
(e-mail address removed)
Paco3517 said:
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 said:
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
(e-mail address removed)
Paco3517 said:
but will i be able to pull up the information if it is in a different
workbook and that workbook is not opened?

:

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)

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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top