Combo-box with Choose formula

[Abdul]

i am using choose formula with combo box. On the basis of "Cell Link"
am retriving the figures shown just against the combo box list e.g

abc 100
def 200
ghi 300

now when i select "abc", with the help of choose formula 100 is show
in cell d1.

The porblem when i insert a new row to the list, (eg above 'def')
the choose formula does not adjust itself to mention its value!
Every time i have to change the choose fromula every change.

Is there any easy way to do it

 

[Dave Peterson]

What kind of combobox is it?

If it's a dropdown from the Forms toolbar, you could use:

=if(c1="","",index(b1:b3,c1))
if your input range were in A1:A3.
(the linked cell will contain a numeric index into that input range).

If your combobox is from the controltoolbox toolbar, then the linked cell will
contain the value in the combobox.

=IF(C1="","",INDEX(B1:B3,MATCH(C1,A1:A3,0)))