=VLOOKUP(E8,Addresses,2,0)On 2002-05-12 18:07, Phil J wrote:
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.
where E8 is the LinkedCell and List is the value for ListFillRange.
In your case List would be the list of surnames.
Hope this helps.
[ This Message was edited by: Aladin Akyurek on 2002-05-12 19:19 ]
[ This Message was edited by: Aladin Akyurek on 2002-05-12 19:24 ]
Like this thread? Share it with others