Combine into one please.

[Steved]

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.

 

[Dave R.]

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


.... assuming E15 contains the first formula.

 

[Steved]

Thankyou very much indeed.

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


.... assuming E15 contains the first formula.





.