I need help matching data between these two columns. I need to find exact matches, AND I need to find missing values between A and B

Question

I have been trying to apply Match, ISNA, IF, VLOOKUP, HLOOKUP and other such functions all day and the values that I get in return are very flawed. Sometimes I get a proper match between A and B in one cell, but other cells return a "missing" value that is incorrect (the value is in fact shared by both columns but it is read as "missing")

Other times, with VLOOKUP especially I keep getting #N/A or #REF! values.

This is VERY urgent for work and it is an emergency

Answer 1

Yes I would like to ask about your specific formula for that. Did you just make a Pivot Table based on the columns and filter it that way? I need a third column that shows all the matching cell objects between Column A and B. Also I need grand totals as well for all 3 columns. Please let me know what I was doing wrong with my formulas.

Answer 2

The first formula True means Object ID is found in Column A

The Second formula True means ChargeCode is found in Column B

Answer 3

I assume "TRUE" means the cell value is found in A and B?
"False" would mean it is only found in one of them yes?

Answer 4

B in A

=IF(COUNTIF(A:A,B2)>0,TRUE,FALSE)

A in B

=IF(COUNTIF(B:B,A2)>0,TRUE,FALSE)

Answer 5

Share a test workbook.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

You may also share it via private message.