Combine into one please.

's Computer Specifications

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.

's Computer Specifications

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

.... assuming E15 contains the first formula.

"Steved" <(E-Mail Removed)> wrote in message
news:137d01c51931$7bb26d30$(E-Mail Removed)...
> 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.

's Computer Specifications

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" <(E-Mail Removed)> wrote in
message
>news:137d01c51931$7bb26d30$(E-Mail Removed)...
>> 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.
>
>
>.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I combine worksheets w/o enough rows to combine?	Amanda W.	Microsoft Excel Worksheet Functions	3	9th Jun 2009 07:26 AM
Combine cells with the same reference and combine quantities	brandon	Microsoft Excel Misc	2	17th Sep 2008 05:44 PM
combine or if	littlelouise1	Microsoft Excel Worksheet Functions	4	7th Jul 2008 09:26 PM
How do I combine IF and OR?	ana_15825 - ExcelForums.com	Microsoft Excel Worksheet Functions	6	30th Jun 2005 04:51 AM
How do I combine these two?	Steve	Microsoft Excel Programming	1	16th Jan 2004 05:25 PM