I have a formula that I use on certain cells in the M column. My method is first I copy a cell that contains the formula, then I do a special paste of ‘formula only’ into the new cell, now the cell has the formula which is what is desired, works fine but… This process can be time consuming as I have to find a cell in the column and paste formula only into the cell I decide on.

Is it possible to have a more efficient method to apply the formula onto a cell? I tired to keep the text of the formula on a separate sheet but pasting just the text does not keep the row numbers in sequence as with the $ sign…

Thank you.

here’s a copy of the formula I’d like to readily apply to cells for context

`=IF(ISNA(VLOOKUP(A4,'Sheet1'.$A$3:$M$1358,MATCH($M$2,$'Sheet1'.$A$2:$'Sheet1'.$M$2,0),0)),"",VLOOKUP(A4,'Sheet1'.$A$3:$M$1358,MATCH($M$2,$'Sheet1'.$A$2:$'Sheet1'.$M$2,0),0))`