How do you force the focus of an Excel Cell to remain the same?
I have a question in the same reference above link. I am trying to match the data I have in Column A and Column B. If data matches it says "Record Matched". If not it says "Record Not Found". Though my issue is that the formula changes it lookup/range values when I insert a new cell in column A
For example, if I insert a cell in Column A to match the cell value in column B, the formula changes its range. I tried to using $ and range.
My end plan is if I insert a cell to move the value down, than the next row should change from "Record Not Found" to "Record Matched"
I tried to explore the Indirect but didn't get the formula correct. I am hoping there is value we can subtract the row to match row values when I insert one or two cell rows.
Any help appreciated
=IF(ISNA(VLOOKUP(B3,A3,2,FALSE)), "Record Not Found", "Record Matched")
Column A Column B Diff
1.1.1.1 1.1.1.1 Record Matched
3.3.3.3 2.2.2.2 Record Not Found
4.4.4.4 3.3.3.3 Record Not Found
4.4.4.4 Record Not Found