I am trying to get the null values in Version, Product, etc columns to auto fill if there is a null value in the rows below. Once it runs into a non Null value it would then change to the new name and continue with the autofill using the new value. The excel formula I am trying to duplicate is: =IF(C2="",C1,C2) This would change the rows under Version to equal Actual until it finds the non null value of "Forecast" in row 200. From there it would autofill 201, etc with Forecast.
