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!
Bookmarks