Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Relational files (Office version X for Mac)

    I am trying to "relate" two files using a key. Specifically, I have two files with a column in each that contains social security numbers or an identifying number. I want to share the information in the secondary file to the main file. I can do this with relational databases. What is the procedure for Excel?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Relational files (Office version X for Mac)

    Use the VLOOKUP function or a combination of the MATCH function, coupled with INDEX.
    The second method is faster is you have many "lookups" using the same identifying number, since it requires only 1 lookup.

    See under the help for more info in these 3 functions.

    Post back with more specific questions if you need additional information.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •