| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting info from a pull down menu and looking up column to get co
Sorry I don't know all the jargon, but basically i have made a list called
employee and used it to make pulldown menus in multiple worksheets to enable me to select an employee for labor costs. Now I want to lookup(from the pull down menu,another list I made Called name, another list i made call rate) to be entered in the rate column. The "name" list='Employee records'!$A$3,'Employee records'!$A$4,'Employee records'!$A$5,etc... The "rate" list='Employee records'!$C$3,'Employee records'!$C$4,'Employee records'!$C$5,etc... =LOOKUP(A8,name,rate) where as a8= The "employee" list='Employee records'!$A$3:$A$54 so i guess an example i would need to show is: A8=pulldown menu employee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I pull info from 3 different workbooks | New Users to Excel | |||
| how do i pull info from one worksheet to another? | Excel Discussion (Misc queries) | |||
| Using a date range in a formula to pull info to the correct column | Excel Worksheet Functions | |||
| Pull info from other worksheets | Excel Discussion (Misc queries) | |||
| How to pull some info into different sheet? | Excel Worksheet Functions | |||
Hybrid Mode
