In the 2nd formula, replace $E$15 with
VLOOKUP("City",FromVertex!$A$1:$C10012,3,0)


.... assuming E15 contains the first formula.


"Steved" wrote in message
...
Hello from Steved

=VLOOKUP("City",FromVertex!$A$1:$C10012,3,0)

returns the data 1128.19

=SUBSTITUTE(TEXT($E$15,"#.00"),".",":")*1

returns the data 1128:19

Is it possible please just to have one Formula not two.

Thankyou.