Re: VLookup or other?

How about an alternative?

Select those three columns and do:
Data|Filter|autofilter

Then you can use those arrows to show the rows that meet your criteria.

Data|Filter|show all

To see everything.

Bruise wrote:
>
> I'm not sure if VLookup is the process I'm looking for, but if it is, I
> can't figure out a way to get it to work. My scenario is this:
>
> I have information listed in 3 columns: Name, Address, Phone. I want to
> use a UserForm to search these columns and display the info.
>
> If a user searches via column A (Name) and it matches, the results show the
> address and phone. If the user searches via column B (Address) and it
> matches, the results show Name and Phone, as well. Same goes if the user
> searches column C for Phone.
>
> Can someone help me or direct me in the right direction to accomplish this
> task? Any help would be truly appreciated.
>
> Mark

--

Dave Peterson
.

Relevant Pages

  • Re: Display all results, even zeros, nulls, and blanks
    ... Thanks John! ... for your requisite criteria and Is Null!! ... way to display all regions in a query. ... display all the results from a table when the results may be zero. ...
    (microsoft.public.access.queries)
  • Re: Making A Search Form Like Albert Kallals Form
    ... > wanting something similar to Albert Kallal's search form ... > I've set up the continuous form which displays the vendor ... Since the display area is a sub-form, ... To do so I assume I will use a query criteria ...
    (microsoft.public.access.forms)
  • Red Arrows and NOTAMS ... again
    ... Attended Day 2 of the Yorkshire Airshow at Elvington yesterday (Aug ... Once again the Arrows had to shorten their display ... ...
    (uk.rec.aviation)
  • Re: Counting only Yes values from a Yes/No field.
    ... Any non-zero, non-Null value will be displayed with a check. ... constraints imposed by its bound field's data type. ... >> non-Null value in the bound field will display a check in ... Using criteria on a boolean field, and, once ...
    (microsoft.public.access.formscoding)
  • Re: Auto Filter-VB
    ... This is from "Excel 2002 VBA Programmer's Reference" ... create a criteria string that will locate an exact match in all locales. ... Can you use Auto Filter w VB to display only certain years in a spreadsheet ...
    (microsoft.public.excel.programming)