I need my combo box to return info in a requested cell

J

Jessica C. Jara

I need my combo box to show on a requested cell information related to the
name in the combo box. I don't remember the formula used for this. Can anyone
help?

Thanks,
 
M

Marcelo

Hi Jessica,

You could create an auxiar column left from your dropdown list (source) with
numbers 1,2,3, etc... like an ID

than put on the cell that you want the result a vlookup formula there will
look for the cell bond value and return the corresponding amount or text

so imagine your bond cell is h150 and the list is on h3:h100 and the ID's on
the G column

=vlookup(h150,$g$3:$h$100,2,0)

HTH
Regards from Brazil
Marcelo

"Jessica C. Jara" escreveu:
 
J

Jessica C. Jara

Hi Marcelo,

Thanks, I tried the vlookup formula but it doesn't help when I change the
combo box.
I have in colum A names from 1-60 and in colum "D" I have the hourly rate of
each name, what I want, in a seperate sheet (same doc) is that every time I
change the name in the combo box, undeneath I can see the rate of the name in
Combo box. I can't remeber the formula to obtain this info, it involves combo
box, rate column and cell c5, that's where the answer should go. I did this
in the past but I can't remember the formula.
 
Top