Re: [ExcelVBA] look up validation

 

not sure if a comma will cause an error (doubt it) it will look professional
guess you can generate an extra column on the far left with
concatenating(!) the fields to the right you need

let me know how you get on

Dr B

On 2 August 2011 10:52, Tony Davis <studiot@gmail.com> wrote:
> Thanks, I'll try that
> On 2 Aug 2011 10:48, "Dr John C Bullas" <john.bullas@gmail.com> wrote:
>> can the drop down choices be <name>,<initials> instead?
>>
>> JB
>>
>> On 2 August 2011 07:39, Tony Davis <studiot@gmail.com> wrote:
>>> Hi Dr b
>>>
>>> Not sure I understand your question.
>>>
>>> On a worsheet I have created a cell which will access a named range of
> cells
>>> containing surnames using a validated list drop down. Adjacent to the
> cell I
>>> have used Vlookup to access another worksheet with details like first
> name,
>>> staff #, 1st line of address etc, simple stuff really. I use it to look
> up
>>> staff addresses, saves me trawling through the main list and it's easier
> for
>>> me to read when the addresses come up one at a time. The only problem is
>>> that, for instance, we have about 5 staff members named Patel, when I use
>>> the drop down cell to find Patel, it will shew all 5, but when I select
> one,
>>> say the second one on the list, Excel always returns the value of the
> first
>>> name on the list. The only way for me to process the names is to go to
> the
>>> worksheet containing the list of names and addresses and look them up
>>> myself. Not terribly difficult, but defeats the object really.
>>>
>>> regards
>>>
>>> Tony
>>>
>>> On 1 August 2011 12:56, Dr John C Bullas <john.bullas@gmail.com> wrote:
>>>
>>>> **
>>>>
>>>>
>>>> What is the trigger to select the 2nd or 3rd say Smith, can you
>>>> process the names you do the lookup on?
>>>>
>>>> Excuse me if I am talking rubbish
>>>>
>>>> Dr b
>>>>
>>>>
>>>> On 01/08/2011, Tony <studiot@gmail.com> wrote:
>>>> > Hi
>>>> > I am using lookup to find address details relevant to particular
> surname.
>>>> > The problem I have is that where there are several surnames with the
> same
>>>> > spelling vlookup always returns the first name in the column.Is there
> a
>>>> way
>>>> > of being able to select another name from the column?
>>>> >
>>>> > Thanks
>>>> >
>>>> > Tony
>>>> >
>>>> >
>>>> >
>>>> > ------------------------------------
>>>>
>>>> >
>>>> > ----------------------------------
>>>> > Be sure to check out TechTrax Ezine for many, free Excel VBA articles!
> Go
>>>> > here: http://www.mousetrax.com/techtrax to enter the ezine, then
> search
>>>> the
>>>> > ARCHIVES for EXCEL VBA.
>>>> >
>>>> > ----------------------------------
>>>> > Visit our ExcelVBA group home page for more info and support files:
>>>> > http://groups.yahoo.com/group/ExcelVBA
>>>> >
>>>> > ----------------------------------
>>>> > More free tutorials and resources available at:
>>>> > http://www.mousetrax.com
>>>> >
>>>> > ----------------------------------Yahoo! Groups Links
>>>> >
>>>> >
>>>> >
>>>> >
>>>>
>>>> --
>>>> Sent from my mobile device
>>>>
>>>> ===========================
>>>> http://uk.linkedin.com/in/drjohnbullas
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> Save paper - do you really need to print this email?
>>> Save electricity - do you really need to send this email?
>>> Save your own energy - do you really need to read this email?
>>>
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>>
>>>
>>> ------------------------------------
>>>
>>> ----------------------------------
>>> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
> ARCHIVES for EXCEL VBA.
>>>
>>> ----------------------------------
>>> Visit our ExcelVBA group home page for more info and support files:
>>> http://groups.yahoo.com/group/ExcelVBA
>>>
>>> ----------------------------------
>>> More free tutorials and resources available at:
>>> http://www.mousetrax.com
>>>
>>> ----------------------------------Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>
>>
>>
>> --
>> ===========================
>> http://uk.linkedin.com/in/drjohnbullas
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>

--
===========================
http://uk.linkedin.com/in/drjohnbullas

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (6)

Recent Activity:

• New Members 7

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___