I have a dropdown control that displays a list of Offices by their three letter abbreviation. Once choosen it puts the 'Value" which is their address in a text field. Now I need another Text field to display a certain account reference which is text, when they choose thier specific Office Abbreviation. The formula ...