Results 1 to 4 of 4

Matching 1 set of Columns with a 2nd set of Columns

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2019
    Location
    Oregon, USA
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20116) 64-bit
    Posts
    89

    Matching 1 set of Columns with a 2nd set of Columns

    I am trying to compare cells D4 - I4 with cells in K4 - P4. If one of the cells in D4 - I4 matches the cell that is marked in K4 - P4 it will record a HIT in C4.

    If the cells in D4 - I4 does not make a match with the cells in K4 - P4 it will return a MISS in C4.

    If there is no data in D4- I4 and K4 - P4 it will show a blank in C4.

    I was on another site and they were very helpful, but I could not upload my spreadsheet. When I tried their suggestions I just keep getting a #VALUE! error. Thanks for your help.
    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. [SOLVED] arrange data based on matching for four columns together with two columns together sheets
    By Mussa-A in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2022, 05:36 PM
  2. Search by columns headers and paste all matching columns to another sheet
    By maamon in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-13-2021, 10:10 AM
  3. matching 2 columns to 2 columns to display price from 3rd col
    By razer1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-27-2015, 03:41 PM
  4. Align 3 columns with 2 columns of matching data
    By bearnbillie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2012, 08:33 AM
  5. Replies: 3
    Last Post: 06-09-2011, 05:58 AM
  6. sort columns based on matching 1st & 2nd columns
    By repke in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-13-2011, 01:37 PM
  7. compare columns and count number of matching columns
    By san000 in forum Excel General
    Replies: 1
    Last Post: 07-15-2009, 10:31 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