I have created a combo box in sheet using the control toolbox function and defined the list of surnames. I want to be able to create an "if" statement that looks at the entry selected in the combo box and gives the corresponding address. I have allocated a name to the combo box and used that name in an "if" statement but only get a false result. Any assitance appreciated.