Spotty Logic (spottylogic) wrote,
Spotty Logic
spottylogic

  • Mood:
=IF(VLOOKUP(G8,'[1107 Product (Achieve) - Active.xls]Product'!$C:$T,18,FALSE)/5>VLOOKUP(H8,'[1107 Product (Achieve) - Active.xls]Product'!$C:$T,18,FALSE),VLOOKUP(G8,'[1107 Product (Achieve) - Active.xls]Product'!$C:$T,18,FALSE)/5,VLOOKUP(H8,'[1107 Product (Achieve) - Active.xls]Product'!$C:$T,18,FALSE))

Yay! Four v-lookups in a single equation!
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 5 comments