I'm trying to get a drop down list to autoselect an option based on the entry in another cell. On my workbook, dropdown 'case status' in column G of the 'live' sheet has a number of dropdown options, one of which is 'referral denied'. On the 'point of referral' sheet, column F 'referral outcome' has a number of options. If someone selects any of the four 'declined' options, I would like the 'case status' on 'live info' sheet to automatically select 'referral denied', but all the options to be available to staff to overwrite or to use for accepted referrals. Help 
