Hi there,

I am creating a workbook and I can not find the way to make my combo box
work how I want it to:

I have a spreadsheet with names, colum a from 1 - 89. With this list I have
created a combo box, on Colum B, from 1 - 89 rates ($). What I would like to
do is every time I change the name in the combo box I want cell B to show me
that persons rate.

Is there anyone that can help!!!!!

I've been working on this same problem for a week, I'm going crazy Please
help!!!
Thanks!!!!