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

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.
 
G

Guest

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 List 2
Drop Down Lists - Shrinking the List 5
Drop down / validation / lookup into the same cell 2
Filtered drop down list 2
Create Drop Down Box populated by a List 1
Drop down list 1
Excel Excel: How do I put a formula in a drop down list 11
Fill Drop Down with List 2

Top