combobox & lookup
Posted by Kent H. Caudill on December 03, 2001 9:28 AM
I have a list of labor union locals and the local wage rates. I want to use a ComboBox to select a union local from the drop down list. Then use VLookup to display the wage rate for the selected local in a cell adjacent to the drop down list. Thanks for your help.
Kent.
Posted by Ted on December 03, 2001 9:53 AM
Why not list them simultaneously in the ComboBox?
Posted by Aladin Akyurek on December 03, 2001 10:58 AM
Give a name to the list that will serve as source to the ComboBox, e.g., UList via the Name Box on the Formula Bar. Don't forget linking the ComboBox to a cell (via Cell Link). Name the table that contains union locals and wage rates, e.g., TABLE, via the Name Box.
The following VLOOKUP formula would allow you to retrieve the local wage rate associated with the choice from the ComboBox:
=VLOOKUP(INDEX(UList,cell-link),TABLE,2,0)
You have here the flexibility to expand your TABLE with any other info that might be relevant.
Aladin
