how do I create a drop down list that assigns certain information

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

Guest

I am trying to create a drop down list of employes. I would like it to
auotmatically bring up each employees specific pay rate in another cell.
 
Look at VLOOKUP function.

Create table of names and asociated pay rates.

In your "rate" cell:

=VLOOKUP(name,PayRates,2,0)

where "name" is cell of your drop down

PayRates is named range (2 columns) containinng names & rates

HTH
 

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

Drop Down Lists - Shrinking the List 5
Filtered drop down list 2
Drop down list and macros? 1
Drop Down List 2
Drop down / validation / lookup into the same cell 2
Fill Drop Down with List 2
Create Drop Down Box populated by a List 1
Drop down list 1

Back
Top