ExcelBanter - Combine into one please.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Combine into one please. (https://www.excelbanter.com/excel-worksheet-functions/14511-combine-into-one-please.html)

Steved

Combine into one please.

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" 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.

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.

"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.

.

All times are GMT +1. The time now is 02:21 AM.