combobox & lookup

Kent --

I don't understand.

Lets say that you have the following:

union1 10
union2 20
union3 30

in A2:B4 in Sheet2.

Select A2:A4, go to the Name Box on the Formula Bar, type MyList, and enter.

Select A2:B4 (now the entire table), go to the Name Box, type mytable, and enter.

Now create a ComboBox, say in A5, in Sheet1 with

as Input Range -> MyList
and as Cell Link --> A5

Enter in some cell say in Sheet1:

=vlookup(index(MyList,A5),mytable,2,0)

will give you the wage associated with the selection made from the ComboBox.

PS. There was really no need to start another thread on the same question.

Aladin

==========

All the while ignoring the wages in mytable. I can't list them simutaenously in the combobox (1) because the linked wages cell is used in a formula to calculate labor costs, (2) wages are in seperate cells representing the sum of all labor costs, taxes, benefits etc. Am I missing a formula to tie the combo box to mytable? Thanks, Kent.

Aladin:
Thanks for taking the time. I created a practice table similiar to your example in range A1:B6 on sheet 10.
Union Wages
102 10
103 15
104 20
105 25
106 30
I named A2:A6 mylist. I named A2:B6 mytable. I placed a combo box in cell E11 on sheet 9. The linked cell is E8. The ListFillRange is mytable.
I entered =vlookup(index(mylist,E8),mytable,2,0) in cell E7 on sheet 9. When I click on a union local in the drop down list the local number is displayed in the combobox and in the linked cell E8. #REF is displayed in cell E7.
Kent.

: Thanks for the input. The formula =vlookup(index(MyList,celllink),mytable,2,0) returns the union local name from the combo box list to the linked cell. union2 20 union3 30 and as Cell Link --> A5

Kent --

Just sent you a workbook that shows the example.

I note that you mention "The ListFillRange is mytable". My description does not mention such a step. Maybe that's the problem, but first have a look at the workbook to see if it meets your needs.

Aladin

========== : Thanks for taking the time. I created a practice table similiar to your example in range A1:B6 on sheet 10. Union Wages 102 10 103 15 104 20 105 25 106 30 I named A2:A6 mylist. I named A2:B6 mytable. I placed a combo box in cell E11 on sheet 9. The linked cell is E8. The ListFillRange is mytable. I entered =vlookup(index(mylist,E8),mytable,2,0) in cell E7 on sheet 9. When I click on a union local in the drop down list the local number is displayed in the combobox and in the linked cell E8. #REF is displayed in cell E7. Kent.