Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do you perform a VLOOKUP in Access?

Discussion in 'Information Technology' started by miztahprofessa, Nov 16, 2005.

  1. miztahprofessa

    miztahprofessa
    Expand Collapse
    Guest

    I need to perform the equivalent of a vlookup in Access. Is there any way to
    do it?
     
  2. Loading...

    Similar Threads Forum Date
    Heritage Amritsar to witness vintage performance of ragas from Guru Granth Sahib today History of Sikhism Sep 3, 2013
    Controversial Hazoori Ragi reportedly refused to perform Kirtan at DSP Swaran Ghotna’s bhog Hard Talk Feb 25, 2013
    India Perform or perish; Punjab govt tells all its employees Breaking News Aug 30, 2012
    Leisure Humble the Poet's First London Performance Business, Lifestyle & Leisure Sep 21, 2011
    Verse Novel of Hindu-Sikh Romance a Bravura Performance Book Reviews & Editorials Jul 16, 2011

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    See whether DLookup meets your needs.

    Note, though, that while the display of tables in Access makes them look
    like spreadsheets, they aren't. Using relational databases requires a fairly
    significant mindset change from using spreadsheets. Perhaps if you explained
    what you're trying to do, someone can help you.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "miztahprofessa" <miztahprofessa@discussions.microsoft.com> wrote in message
    news:682F588F-D864-4FD8-8303-0ADE43D2191E@microsoft.com...
    > I need to perform the equivalent of a vlookup in Access. Is there any way

    to
    > do it?
     
  4. Smartin

    Smartin
    Expand Collapse
    Guest

    miztahprofessa wrote:
    > I need to perform the equivalent of a vlookup in Access. Is there any way to
    > do it?


    IME Excel's "Vlookup" translates to the simplest form of a SELECT SQL
    statement.

    E.g., suppose you have a database table organized like this:

    Person Preference
    --------------------
    Adam Apples
    Olivia Oranges
    Bert Bananas
    Polly Pomegranates

    In Excel you may have done something like the following to find which
    Preference Olivia has:

    =VLOOKUP('Olivia', <range of data>, 2, False)

    With SQL in a database you do it like this:

    SELECT Preference FROM MyTable WHERE Person = 'Olivia';

    These would return the same value ('Oranges').

    It may not be obvious from this example but there is much more
    flexibility in the database/SQL structure. To name just a few benefits:

    + you can return data from either "side" of the "lookup" column, left or
    right, or from entirely different (but related) tables
    + multiple fields can be returned from the matching record (not just one)
    + you can choose multiple criteria to match across different fields
    + you can aggregate and sort the returned data all in one statement


    Hope this gives you some ideas.
    --
    Smartin
     

Share This Page