Cell for entry and look up

MelissaSan

Hi,

My finance team has asked me to create a sheet where we are capturing forecasted and actuals. To simplify the example:

they want a Column for each month.

Jan, Feb, March etc…. they want the business to enter a value for each month but when the actuals are in, they want that same cell to be a vlookup and summation from another sheet and then locked.

I don't know if it is possible for a cell to be a formula and accept a value.

Any insight on this?

bisaacs

Hey @MelissaSan,

Unfortunately you can't have the ability for both a column formula and accept a value. However, what if you had a master sheet that pulls from two separate sheets, one for Estimates and another for Actuals, then just have it check if the Actuals sheet is blank, use Estimates?

bisaacs

Hey @MelissaSan,

Unfortunately you can't have the ability for both a column formula and accept a value. However, what if you had a master sheet that pulls from two separate sheets, one for Estimates and another for Actuals, then just have it check if the Actuals sheet is blank, use Estimates?

MelissaSan

Thanks!