Results 1 to 2 of 2
  1. #1
    masond is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    12

    Need to mirror Vlookup on excel to access !

    HI All

    I need some help

    I am very new to Access so please be patient

    I have two tables imported into access
    Marketing
    Lookup

    I have started to build a query called “query1”. Query1, manipulates the “Marketing Table”. In my query i have the created the following

    Column: Channel
    Formula : IIf([Sub-Source] Is Null,[How did you hear of us],[Sub-Source])

    I would like to create a look up from “Channel” To the lookup table

    Within the LookupTable i have the following 3 columns
    Id
    Field1
    Channel



    The link between channel (column in the query) needs to be on field1, and returns “Channel” on the “Lookup Table”

    Looking for some step by step guides
    In excel i do this via a vlookup. (kinda looking for same logic but in access)

    Would appreciate any help available

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    What is the relationship of these tables? Did you try joining them in a query? Access Help has info on building queries that join related tables.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VLookup function in Access?
    By mveda2004 in forum Queries
    Replies: 2
    Last Post: 02-25-2013, 09:42 PM
  2. Access and the concept VLOOKUP in Excel
    By Bob Blooms in forum Access
    Replies: 1
    Last Post: 08-27-2012, 12:28 PM
  3. Excel VLookup vs Access IIF statement
    By Huddle in forum Queries
    Replies: 9
    Last Post: 02-02-2012, 11:00 AM
  4. Vlookup in Access with SQL
    By jogunjobi in forum Queries
    Replies: 1
    Last Post: 01-30-2012, 07:25 PM
  5. How to Mirror Access in MySQL???
    By s3rvant in forum Database Design
    Replies: 0
    Last Post: 07-28-2009, 08:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums