+ Reply to Thread
Results 1 to 3 of 3

Rule to match column data with one of two other columns

  1. #1
    Registered User
    Join Date
    06-29-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    1

    Rule to match column data with one of two other columns

    I am trying to create a rule to ensure that data in Column E (starting at E2) will match either Column F (F2) OR Column G (G2). I want the rule to apply from row 2 ongoing. There is an entry in either Column F or Column G but never both. For accounting purposes I want to be sure that Column E will be an exact match to Column F or Column G.
    Here's a hypothetical Example
    (column E) (column F) (column G)
    (row 2) $2175.19 $2175.19
    (row 3) $1445.22 $1445.22

    Any suggestions? I would hate to have to verify each row manually if there were an accounting error at year end.

    Thanks in advance.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,595

    Re: Rule to match column data with one of two other columns

    Data validation for E2:
    =OR(E2=F2,E2=G2)
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Rule to match column data with one of two other columns

    another way would be to use conditional formatting. set up the CF to highlight either a match or a non-mathc, whichever you would prefer to have high-lighted
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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