I wish to automatically fill in column 'B' depending what someone enters in column 'A'
For example, if someone enters the value '43' in column 'A', then I want column 'B' to automatically enter '100,000'
Column 'A' is using Data validation, therefore has a limited field of entry (see attached...