Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

How do you perform a VLOOKUP in Access?

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

  1. miztahprofessa

    Expand Collapse

    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

    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
    (no e-mails, please!)

    "miztahprofessa" <miztahprofessa@discussions.microsoft.com> wrote in message
    > I need to perform the equivalent of a vlookup in Access. Is there any way

    > do it?
  4. Smartin

    Expand Collapse

    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

    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.
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page