+ Reply to Thread
Results 1 to 2 of 2

Need a Formula to Highlight Matches between 2 Tables in Excel

  1. #1
    Registered User
    Join Date
    06-07-2023
    Location
    SC, USA
    MS-Off Ver
    Version 2303. Excel
    Posts
    1

    Red face Need a Formula to Highlight Matches between 2 Tables in Excel

    Hi everyone!

    I've been trying to figure this out for the longest time and can't get any of my formulas to work, so I'm hoping you guys can help me lol.

    So, I need some help creating a formula that searches for exact matches between 4 columns of 2 different tables and either highlights or returns true if a match is found.

    For example: TableA has a column named 'PO#' and one called 'QTY'. TableB also has these 2 columns. I want the formula to search through TableA's 'PO#' and 'QTY' columns and highlight/confirm that TableB's 'PO#' and 'QTY' column matches.

    I'm basically just trying to make sure the PO# and qtys on my sales entry report matches the PO# and qtys on my customer's forecasted order. Forecasts can be thousands of lines long so looking though these manually is so tedious.

    I'm open to any suggestions!

    I've also attached an example file.

    Thanks everyone!
    Attached Files Attached Files

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

    Re: Need a Formula to Highlight Matches between 2 Tables in Excel

    For table6:
    Please Login or Register  to view this content.
    table7:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight Matches?
    By watson150 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2022, 01:40 PM
  2. Compare two tables, find matches, and extract rows based on matches.
    By arcticspace in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2022, 06:35 AM
  3. Formula To Check & Highlight Matches
    By rahul_ferns76 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2017, 09:51 AM
  4. Highlight column matches
    By joeyga in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-03-2013, 11:11 PM
  5. Highlight rows if A matches but B is different
    By SpeedyOne18 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-07-2013, 08:05 PM
  6. Replies: 12
    Last Post: 07-24-2012, 06:15 PM

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