Spotty Logic (spottylogic) wrote,
Spotty Logic
spottylogic

  • Mood:

Distinctive *HAACK*, HAAAACK, *cough* of hairball

=IF(VLOOKUP(TRIM(B3),'Stock Record'!B:F,3,FALSE)="--","--",IF(TODAY()-VLOOKUP(TRIM(B3),'Stock Record'!B:F,3,FALSE)>180,VLOOKUP(TRIM(B3),'Stock Record'!B:F,3,FALSE)/6,VLOOKUP(TRIM(B3),'Stock Record'!B:F,3,FALSE)/2))
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 2 comments