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