Looking to replace contents of a cell with a formula

[s4driver]

I am looking to replace the contents of selected cells in column E with a formula with in a macro. For each cell in column E sheet1 that equals "Not Assigned" I want the macro to replace it with the following formula =iferror(vlookup(cell.offset(, -4),'sheet2'A:C,3,false),"Not Assigned"). The file typically has 25k-30k rows, cell.offset(, -4) needs to be dynamic so the formula is looking a the cell in column A of the row that it finds a "Not Assigned" in column E.

thanks, s4

[AndyLitch]

You could do a straight Edit-Replace (CTRL-H) ??

[s4driver]

I'm lookin g to do it within the macro. The formula has to to be slightly different in each row. Row 10 will be =iferror(vlookup(A10,... Row 2000 would be =iferror(vlookup(A2000,... etc. After the macro is ran the user will fill in column C on sheet2 (which is the return value for the formula on sheet1).

[s4driver]

I figured it out.

this is the code that I was looking for earlier.

found6.FormulaR1C1 = "=IfError(Vlookup(RC[-4],'Over 500K'!C1:C3,3,FALSE),+R1C5)"