Results 1 to 4 of 4

match multiple fields in records

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    Mountain View, CA
    MS-Off Ver
    Excel 2003
    Posts
    46

    match multiple fields in records

    Hi All,

    I know how to see if one value exists in an arrray, but is there a way to see if a combination of fields in one array exist in the same combination in another array?

    In other words, if I have table A:

    Name City
    Alyssa Cleveland, OH
    Derek Pittsburgh, PA
    Larry San Francisco, CA
    Merl Provo, UT

    and table B:

    Name City
    Alyssa Pittsburgh, Pa
    Derek Cleveland, OH
    Larry San Francisco, CA
    Merl Philadelphia, Pa

    I would like to add a column to table B containing a function that would indicate, in this instance, that only Larry-San Francisco, CA is a record shared by both tables.

    Can anyone help me with what that function would like?
    Last edited by prawer; 08-06-2009 at 01:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1