| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I make a master look-up list in Excel?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a master list from other sheets | Excel Worksheet Functions | |||
| comparing 3 s/s to make up a master | Excel Worksheet Functions | |||
| Make inventory sheet to track, order & reduce quantity from master | Excel Worksheet Functions | |||
| Update master list with other lists | Excel Worksheet Functions | |||
| Is it possible to setup a self-updating master list? | Excel Discussion (Misc queries) | |||
Threaded Mode
