| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Employee Wage Lookup
I have a column that has a drop down list of employee names (50ea).
I would like the cell in the next column to automaticaly insert the wage rate for the emplyee name selected. How do I it ? |
|
#2
|
|||
|
|||
|
by using VLOOKUP see
http://www.mvps.org/dmcritchie/excel/vlookup.htm You can probably put that next to the employee name in the table you use to create the dropdown, but you will still have to use VLOOKUP.. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rick" wrote in message ... I have a column that has a drop down list of employee names (50ea). I would like the cell in the next column to automaticaly insert the wage rate for the emplyee name selected. How do I it ? |
|
#3
|
|||
|
|||
|
David
Thanks for the answer. Could I impose on you a little more. After looking at the page you refered me to I am still lost. Any chance you could give me an example of a formula? "David McRitchie" wrote: by using VLOOKUP see http://www.mvps.org/dmcritchie/excel/vlookup.htm You can probably put that next to the employee name in the table you use to create the dropdown, but you will still have to use VLOOKUP.. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rick" wrote in message ... I have a column that has a drop down list of employee names (50ea). I would like the cell in the next column to automaticaly insert the wage rate for the emplyee name selected. How do I it ? |
|
#4
|
|||
|
|||
|
Hi Rick,
Look at the #catalog example on the page. Suppose you had a table like the first table in the #catalog example where you only brought in the Stock Numbers into the dropdown box. Once the user has made a choice, the VLOOKUP can obtain the description and a separate VLOOKUP can obtain the price based on the Stock Number. value. So you are reutilizing the same table -- if you used a table to create your dropdown in the first place. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rick" wrote in message ... David Thanks for the answer. Could I impose on you a little more. After looking at the page you refered me to I am still lost. Any chance you could give me an example of a formula? "David McRitchie" wrote: by using VLOOKUP see http://www.mvps.org/dmcritchie/excel/vlookup.htm You can probably put that next to the employee name in the table you use to create the dropdown, but you will still have to use VLOOKUP.. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rick" wrote in message ... I have a column that has a drop down list of employee names (50ea). I would like the cell in the next column to automaticaly insert the wage rate for the emplyee name selected. How do I it ? |
|
#5
|
|||
|
|||
|
David
Thanks much---got it now. "David McRitchie" wrote: Hi Rick, Look at the #catalog example on the page. Suppose you had a table like the first table in the #catalog example where you only brought in the Stock Numbers into the dropdown box. Once the user has made a choice, the VLOOKUP can obtain the description and a separate VLOOKUP can obtain the price based on the Stock Number. value. So you are reutilizing the same table -- if you used a table to create your dropdown in the first place. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rick" wrote in message ... David Thanks for the answer. Could I impose on you a little more. After looking at the page you refered me to I am still lost. Any chance you could give me an example of a formula? "David McRitchie" wrote: by using VLOOKUP see http://www.mvps.org/dmcritchie/excel/vlookup.htm You can probably put that next to the employee name in the table you use to create the dropdown, but you will still have to use VLOOKUP.. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rick" wrote in message ... I have a column that has a drop down list of employee names (50ea). I would like the cell in the next column to automaticaly insert the wage rate for the emplyee name selected. How do I it ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Referencing a newly created worksheet | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Hybrid Mode
