Combo-box with Choose formula

i am using choose formula with combo box. On the basis of "Cell Link" i
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 shown
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?


---
Message posted from http://www.ExcelForum.com/

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


"Abdul " wrote:

i am using choose formula with combo box. On the basis of "Cell Link" i
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 shown
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?

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson