Re: [ExcelVBA] look up validation

 

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]

__._,_.___

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

Messages in this topic (3)

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

.

__,_._,___