Hello all,
I am running into a problem and excel (O365 64bit) seems to not be able to grasp what I am asking of it. Likely a me issue, but its formula help thing keeps telling me to add an apostrophe at the beginning to make it text and not a formula.

I am trying to do some data comparisons from reports, as the reports are generated by software that cant sort, nothing is in the same order but there are many duplicates, i have 1 report that is 467 rows and one that is 596, these are A and B respectively. I am trying to compare the two and show the differences, specifically the new data from the larger report. Here is what I used, but i am getting errors.
=INDEX($A$1:$A$467,MATCH($B$1:$B$596,0))
It says a value is not available for this formula to function, however I can compare them manually and find matches.

I also tried highlighting both columns going to Find&Select - Go To Special - Row Differences (also tried Column Differences) it gave no error but no result, so I am at a bit of a roadblock. Anyone tell me what im doing wrong?