Re: [ExcelVBA] look up validation

 

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

__._,_.___

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

Messages in this topic (4)

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

.

__,_._,___