I have solution of tony's problems i.e. Excel Vlookup / Validation in Excel Work book .How can I send attachment of Excel workbook to Tony and Group
Pl. guide me because of I am new in group.
________________________________
From: Tony Davis <studiot@gmail.com>
To: ExcelVBA@yahoogroups.com
Sent: Tuesday, 2 August 2011 3:22 PM
Subject: Re: [ExcelVBA] look up validation
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]
[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
----------------------------------
Tidak ada komentar:
Posting Komentar