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
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