Linking VLookup and Combo Box

**Coldshadow686** · 05-09-2013, 11:55 AM

Hi There,

I have a long list of positions that I had original in a drop down box, through data validation. However, I could hardly see the positions in the drop down so I looked for a workaround.

I used a combobox to display and select the data.

What I want to do now is, when a position is selected in the combobox, a corresponding value will appear in a separate cell. For example, If I pick electrical engineer in my combobox, his/her rate will pop up in another box.

I've attached an excel file that basically shows what I am doing.combobox.xls You will see the combobox with positions, then on the second sheet the corresponding rates. I need the rates to pop up on the first sheet under "rate" when I pick a position in my combobox.

combobox.xls

Any help is greatly appreciated!!!

Thank you,
Nick

**AndyLitch** · 05-09-2013, 11:59 AM

Go to Combobox -> properties ...
Find the LinkedCell property
Enter a cell ref in the form =A1

**Coldshadow686** · 05-09-2013, 12:07 PM

Thanks Andy. So now my chosen position shows up in a cell. If I have 100 lines of people I need to pick positions for, will I need to link a different cell for each line?

Also, and apologies for the n00bness, what comes next? How would I link the position that just popped up in A1 to the corresponding rate on sheet 2?
Thanks again
Nick

**AndyLitch** · 05-09-2013, 12:20 PM

I think A1 will have the selected name in it... You can then use that as a basis for Vlookup or Match against a list of the names in your combobox to return a row position which you can then use in an offset.

Tell you what - it would be easier to upload a sample file