Large Database Need to Compare Two "Code "Columns in New and Old File to Be True or False

I have over 1 million rows of data that I need to determine if Column B (Code) and Column G (Code) match when using unique numbers found in Column A & F. If A&F match, then Column B & G should match. If yes, then True, if no, then False.

I only put in 30 rows in the attached file. So no worries about a huge attached file.

How about

Please Login or Register  to view this content.

In your test file the numbers in col F are stored as text, these will need to be converted to numbers for this to work.
This will put the word False into col I if it's not a match

I am not knowleable on how to use code. Where do I put the code?

I've added the code for you

convert your column F to store as number first.
then try this
=IFERROR(IF(AND(MATCH(F2,A:A,0),MATCH(G2,B:B,0)),TRUE),FALSE)

I am unable to figure out how to run the code.

Also on the finalazy, it returns True. Incident Numbers in A and F could be different with most the same and in order.

you can try with PowerQuery (because Windows 7 Pro is not an Excel version you'll need PoqwerQuery add-in for Excel 2010 or 2013, or Excel 2016 with PowerQuery built-in)

I've added a button to run the macro.
You'll need to ensure that macros are enabled

How do I add this to my large database?

Have a look at this article https://support.office.com/en-us/art...7-a71f7e626de0

Then you can either add a shape & assign the macro to it. or press Alt F8, select the macro 7 click run

Originally Posted by pick44

I am unable to figure out how to run the code.

Also on the finalazy, it returns True. Incident Numbers in A and F could be different with most the same and in order.

ah my mistake. didn't try it out.

Should be
=IFERROR(IF(INDEX(B:B,MATCH(F2,A:A,0))=INDEX(G:G,MATCH(F2,F:F,0)),TRUE,FALSE),FALSE)

fluff and sandy method can work out as well.