Marcelo, I have another inconvenient: Though you did get that option awesome,
I need to do the same with another 5 options, is that possible to do? I'm
trying it but it doesn't happen.

ANy help appreciated. Thanks!!!!

"Marcelo" wrote:

thanks for the feedback and you are close is
Muito obrigado!!!!

regards

"Jessica C. Jara" escreveu:


Marcelo!!! You did it, you're a genius. Thank you so much. I have been
working with this all week!!!!

Obrigado!!!! Moito (I think)

Jessie


"Marcelo" wrote:

Hi Jessica if I understand what you have is

Col A Col B
name1 $10.00
name2 $12.00
...
name88 $7.00

your combo box have a bond cell right? assuming it is on A100 this cell will
change the value for each name select.

insert a column before A, put an ID so

COL A COL B COL C
1 name1 $10.00

use a =VLOOKUP($A$100,$A$1:$C$89,3,0)

and excel will return the Col C value

HTH
Regards from Brazil
Marcelo

"Jessica C. Jara" escreveu:

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!!!!