Results 1 to 5 of 5

Cross referencing 2 Columns, but formula isn't properly working.

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2017
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Microsoft Office 365 Business
    Posts
    3

    Cross referencing 2 Columns, but formula isn't properly working.

    I am trying to cross-reference 2 columns. Column G has a list of Specialties and Column I is the column that needs to be checked if any of those terms are in Column G.

    The formula I am using is =IF(OR(COUNTIF($G3,"*"&I3&"*")),"Match","No Match"). AS you can see in the screenshot you can see that there are matches and no matches. The very first instance shows in D2 but if you check both columns G & I; Column I does in fact have those terms in column G but shows to be a no match.

    What am I missing or what am I not doing right?
    Attached Files Attached Files
    Last edited by j7house; 11-04-2022 at 01:49 PM. Reason: Adding sample workbook

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cross Referencing 2x Columns
    By Kevin Rush in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-01-2022, 01:37 PM
  2. [SOLVED] Cross referencing and duplicating columns?
    By athletics in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-13-2016, 10:27 AM
  3. Cross-Referencing Rows to Columns
    By kejgel in forum Excel General
    Replies: 1
    Last Post: 07-08-2015, 04:50 PM
  4. [SOLVED] Cross referencing columns.
    By SloopJohnB in forum Excel General
    Replies: 2
    Last Post: 09-10-2013, 03:45 AM
  5. formula for cross referencing partial match and returning values from 2 columns
    By 5thgenbliss in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2013, 04:11 PM
  6. Cross referencing columns
    By HevyBreathinHarlot in forum Excel General
    Replies: 2
    Last Post: 11-09-2009, 08:48 AM
  7. Excel 2007 : Cross Worskeet Formula not working properly
    By Ra21V12eN in forum Excel General
    Replies: 2
    Last Post: 02-10-2009, 02:57 PM

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