Hi Walter,

Am Sun, 18 Aug 2013 08:25:28 +0100 schrieb Walter Briscoe:

<=INT(--(A2<A1)*VLOOKUP($F2,Stations,38,TRUE)+--(A2<A3)*VLOOKUP($G2,St
ations,38,TRUE))

try:
=INT(IF(A2<A1,VLOOKUP($F2,Stations,38,TRUE))+IF(A 2<A3,VLOOKUP($G2,Stations,38,TRUE)))


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2