getting info from a pull down menu and looking up column to get co

J

Jason Jessup

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can you look up info from a validated drop down menu in excel 2007 1
Pull-down Menu - 0
Multiple Column Criteria which deletes all but Highest Value 8
create pull down menu 1
Prefilling a text box based on drop down selection 1
Need to select record based on date 5
Transpose large data from columns to rows 3
Name Range, Variable # of Rows, Compare data, then Keep or delete 1

Top