I am auto-updating a daily productivity sheet for employees, and I
need to know how to do the following:

=IF($B$1<1,"",IF($B$1=1,VLOOKUP($A4,$A$3:$B$68,2,FALSE),????????))

I need to know what I can put in the ???????????????? part for the
false statement in order to have the value that is currently stored in
the cell remain the same, without creating a circular reference. Is
that possible?

On 29 Aug, 17:02, Matt Russell <mdr...@gmail.com> wrote:
> I am auto-updating a daily productivity sheet for employees, and I
> need to know how to do the following:
>
> =IF($B$1<1,"",IF($B$1=1,VLOOKUP($A4,$A$3:$B$68,2,FALSE),????????))
>
> I need to know what I can put in the ???????????????? part for the
> false statement in order to have the value that is currently stored in
> the cell remain the same, without creating a circular reference. Is
> that possible?

Not with a formula (unless someone knows different!) but as this is a
programming group, do it with VBA - use the OPEN event of the workbook
(presumably) and test the value of B1 to set the appropriate value or
formula in your cell