November 16th, 2005

Nose to the Grindstone

(no subject)

=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!
  • Current Mood
    accomplished accomplished