Thread: Daily Updating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Russell Matt Russell is offline
external usenet poster
 
Posts: 1
Default Daily Updating

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,F ALSE),????????))

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?