I have a table of data in a workbook. Each row has a formula that points to that rows row number. Currently the formula is: =--ISNUMBER(IFERROR(SEARCH($L$3,A28,1),""))

After inserting a new record using a UserForm, the record is inserted OK but the row number is now off by one on all the following records. In the formula above, the offending reference s the ,A28,
I would like to have, in this example, reference the row the formula is actually in.

Thank you.