Combo box or Data validation

**shilloh** · 05-27-2011, 04:33 AM

Hi

I have to populate some values in a cell based on the selection made from the drop down. Im not sure which one of it is to be used.

To explain in detail

I have a drop down with four options : 0 -50, 50-100, 100- 2000, >2000
if 0- 50 is selected from the drop down then a value 0 needs to be populated in cell C5
like wise 50-100 , value 10 needs to be populated
100 - 2000, value 20
> 2000 , value 30 needs to be populated in C5

Im quite new to using combo box, kindly suggest which of it should be used(data validation or combo )for the drop down. If Combo box is better, pls let me know how it needs to be done.

Your help will be greatly appreciated!

**TMS** · 05-27-2011, 05:03 AM

Personally, I'd go for Data Validation.

See the attached example to reflect what you have asked for.

Regards

**shilloh** · 05-27-2011, 05:22 AM

Hello

Thankyou I appreciate your quick reply, it gives me what exactly I need. However Im curious , if I have to give some other values at random for each of the drop down option, How do i do it? (As the values are not yet decided)

Moreover the List of options added in the data validation is also visible in the excel sheet. Perhaps we can hide it, but if some user of this sheet deletes the column which has these options, then it would be a problem, im afraid it would not work. any suggestions?

One more help.

I have to insert another drop down Yes and No
If Yes - a value to be assigned (say 10)
If No- a value to be assigned (say 20)

Awaiting your reply

**TMS** · 05-27-2011, 05:52 AM

Have a look at the updated example.

To use a list on another sheet, you have to name the range. You can create dynamic named ranges if the list changes a lot or you need to keep adding on the end ... but that's another question.

One step at a time ;-)

Regards

**shilloh** · 05-27-2011, 05:52 AM

Originally Posted by shilloh

Hello

Thankyou I appreciate your quick reply, it gives me what exactly I need. However Im curious , if I have to give some other values at random for each of the drop down option, How do i do it? (As the values are not yet decided)

Moreover the List of options added in the data validation is also visible in the excel sheet. Perhaps we can hide it, but if some user of this sheet deletes the column which has these options, then it would be a problem, im afraid it would not work. any suggestions?

One more help.

I have to insert another drop down Yes and No
If Yes - a value to be assigned (say 10)
If No- a value to be assigned (say 20)

Awaiting your reply

I have attached the excel, im working on. The reason I have asked the above is i have many such drop downs with values to be populated based on the selection.
Pls suggest me what would be a better way , to populate values for each.
Still a Data validation is fine to use?

**TMS** · 05-27-2011, 06:04 AM

looks like the posts crossed.

See your example. I have applied the validation outlined.

I'll leave you to practise with the others. You don't necessarily need separate lists if the list and the calculation is the same.

Regards

Regards

**shilloh** · 05-27-2011, 06:16 AM

Hello

Thankyou very much. Response was real quick.

Guess its better to define a name for each range and it works well with ur solution. Apologies for more than one question at a time. :-)