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?

Short answer: No
You could do this with a VBA module that detects a change in B1
If interested post your question in the
news:microsoft.public.excel.programming newsgroup
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Matt Russell" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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?
>