I have a spreadsheet I use to match up lists of names buildings or long lists of data that can be thousands of lines long. I need a cell to indicate when two other cells are identical. I am currently using the following formula: =IF(A3=D3, "Match", "No Match")
Unfortunately if I need to add or delete cells from column D (or vice versa) then the formulas from that row and below no longer match up, leaving me to drag the correct formula above through to the end in order to rectify the error.
What formula can I use that will not need this constant adjustment and allow me to delete cells or add cells as I need? Please no visual basic or pivot tables if possible; hopefully this can be done with just a formula.