"locking cells after population"

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I want to not update a cell after it has been populated
with a vlookup function. I have it set to be blank if it
is #n/a. How can I do this without cutting and pasting
values on each individual cell?

I thought I might be able to insert a IF (ISBLANK... in
front of the function I currently have written in the
cells. Will this work?


Thanks so much!
 
Christine,

Yes, it will work in the sense that if your lookup results in #N/A it will
then show a blank, but actually your formula still keeps updated.

=IF(ISNA(Vlookup formula),"",VLookupformula)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top