Results 1 to 6 of 6

Match text in two columns with criteria list

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    76

    Match text in two columns with criteria list

    Hello,
    I would like some help with a formula.
    There are two columns (Col A and Col B) with text in each, and I also have an additional 2 columns (Col E and Col F) with criteria text.
    I need the formula to check if the two separate text entries in Col A and Col B columns match the text in adjacent criteria columns (Col E and Col F), and if so, place a 1 in Col C, if not, 0 in Col C.
    Attached an example spreadsheet to hopefully explain things are little more clearly.

    Thanks in advance for your assistance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index/Match but the second match criteria >0 regarding 3 columns
    By Ben2487 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-29-2014, 12:08 PM
  2. Replies: 0
    Last Post: 11-16-2012, 11:42 AM
  3. Replies: 1
    Last Post: 09-05-2012, 11:39 AM
  4. [SOLVED] Match text in 2 columns, if true output adjacent cell to the match.
    By kenoboy in forum Excel General
    Replies: 3
    Last Post: 07-03-2012, 09:52 AM
  5. Help!! Match Two Columns with different criteria
    By trent172 in forum Excel General
    Replies: 1
    Last Post: 06-09-2012, 01:58 AM

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