Hi

I have a userform that has a combo box with a range name for the sourc
'*names*' e.g. members if a name is not on the list I can add a new nam
e.g. visitors in the combo box to the list and this is then placed i
the same column A on the worksheet.
On the worksheet column B this is also a named range *code* which is t
denote the type of membership.
What I would like to achieve is for the name entered to be checked of
against the list and provide the correct code from column B.
I have tried Lookup but this does not work I think with the list no
being sorted it creates a problem. It is not possible to have the lis
sorted and both members and visitors names need to be in the sam
column on the same worksheet.

Thanks for any help / advice

--
harry5
-----------------------------------------------------------------------
harry50's Profile: http://www.excelforum.com/member.php...fo&userid=2734
View this thread: http://www.excelforum.com/showthread.php?threadid=46854