ExcelBanter - Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Validation (https://www.excelbanter.com/excel-discussion-misc-queries/90278-validation.html)

Chris

Validation

I set up my validation drop down list. One of the items is TELEPHONE 6200. Is
there a way that when someone chooses that item, only the 6200 shows in that
cell? Like using a RIGHT formula? Thanks

Peo Sjoblom

Validation

No, you get what you select, you would need an extra cell for that

Regards,

Peo Sjoblom

"Chris" wrote:

I set up my validation drop down list. One of the items is TELEPHONE 6200. Is
there a way that when someone chooses that item, only the 6200 shows in that
cell? Like using a RIGHT formula? Thanks

All times are GMT +1. The time now is 10:58 AM.