What I'm trying to do is compare two sheets in an Excel workbook, one with a master list of parts and one with a condensed one. All I want it to do is return a value of TRUE when it finds a match in column B and a difference in the corresponding column C. I seem to have the column A part down right (it works on its own), but when it comes to the column B, it returns seemingly random results.
The formula is:
=AND(MATCH(B474,'St. Paul'!B:B,0),C474<>'St. Paul'!C:C)
And I have attached the excel file.
The formula is:
=AND(MATCH(B474,'St. Paul'!B:B,0),C474<>'St. Paul'!C:C)
And I have attached the excel file.
