Looking to replace contents of a cell with a formula

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

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).

I figured it out.

this is the code that I was looking for earlier.

Please Login or Register  to view this content.