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

Hi Harry,

I have tried Lookup but this does not work I think with the list not
being sorted it creates a problem. It is not possible to have the list
sorted

See Vlookup in Excel help. If you use the fourth parameter and set it to
False, the lookup data does not need to be sorted.


---
Regards,
Norman



"harry50" wrote in
message ...

Hi

I have a userform that has a combo box with a range name for the source
'*names*' e.g. members if a name is not on the list I can add a new name
e.g. visitors in the combo box to the list and this is then placed in
the same column A on the worksheet.
On the worksheet column B this is also a named range *code* which is to
denote the type of membership.
What I would like to achieve is for the name entered to be checked off
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 not
being sorted it creates a problem. It is not possible to have the list
sorted and both members and visitors names need to be in the same
column on the same worksheet.

Thanks for any help / advice.


--
harry50
------------------------------------------------------------------------
harry50's Profile:
http://www.excelforum.com/member.php...o&userid=27346
View this thread: http://www.excelforum.com/showthread...hreadid=468548

thanks Norman I will give this a try.

The list cannot be sorted as this would mix up the members and the
visitors.


--
harry50
------------------------------------------------------------------------
harry50's Profile: http://www.excelforum.com/member.php...o&userid=27346
View this thread: http://www.excelforum.com/showthread...hreadid=468548