Results 1 to 10 of 10

function to match values in 3 columns

Threaded View

  1. #1
    Registered User
    Join Date
    02-23-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    6

    function to match values in 3 columns

    Hi Excel Experts,

    I am trying to match a value from column 1 and check if it exist in col 2 and col 3.

    If yes, then output the value(col 1) in the 4th column or just display "true"

    Sample:
    col1 col2 col3 col4
    1 0 2 1 or true <- true because there is "1" in col 2 and col 3
    2 0 1
    3 1 0
    4 3 5
    5 5 6 5 or true


    Thanks in advance for the help!!
    Last edited by brichigo; 05-10-2012 at 11:33 AM.

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